I am Berke

SELECT
	OBJECT_NAME(I.[object_id]) AS [object_name],
	P.[partition_number],
	FG.[name] AS [filegroup_name],
	P.[rows],
	AU.[total_pages],
	CASE boundary_value_on_right
		WHEN 1 THEN 'Less than'
		ELSE 'Less or equal than' END AS [compare],
	PRV.[value]
FROM
	sys.partitions P
JOIN
	sys.indexes I ON P.[object_id] = I.[object_id] AND P.[index_id] = I.[index_id]
JOIN
	sys.partition_schemes PS ON PS.[data_space_id] = I.[data_space_id]
JOIN
	sys.partition_functions PF ON PF.[function_id] = PS.[function_id]
LEFT OUTER JOIN
	sys.partition_range_values PRV ON PF.[function_id] = PRV.[function_id] AND P.[partition_number] = PRV.[boundary_id]
JOIN
	sys.destination_data_spaces DDS ON DDS.[partition_scheme_id] = PS.[data_space_id] AND DDS.[destination_id] = P.[partition_number]
JOIN
	sys.filegroups FG ON DDS.[data_space_id] = FG.data_space_id
JOIN
	(
		SELECT [container_id], SUM([total_pages]) AS [total_pages] FROM sys.allocation_units GROUP BY [container_id]
	) AU ON AU.[container_id] = P.[partition_id]
WHERE
	I.[index_id] < 2