SCCM Report- Ad attributes

[bdazle]

Hi All,

I have extended the 'active directory user discovery' to collect some additional attributes like telephonenumber, manager, department etc.

I have created a new report which should show this data but unfortunately its not showing any results. I am assuming this is due to some of the users having blank attributes in AD. Is there a way to show these blank attributes in a report or a way around it.

 

This is the query in case anyone wants to see :

 

SELECT DISTINCT
v_GS_SYSTEM.Name0 AS 'Computer Name',
v_R_System.User_Name0 AS 'USERID',
v_R_user.displayName0 As 'Full Name',
v_R_user.telephoneNumber0 As 'Landline Number',
v_R_user.mobile0 As 'Mobile Number',
v_R_user.company0 As 'Company',
v_R_user.department0 As 'Department',
v_R_user.title0 As 'Title',
v_R_user.manager0 As 'Manager',
v_R_System.AD_Site_name0 AS 'Site name',
v_GS_COMPUTER_SYSTEM.Manufacturer0 as 'PC Manufacturer',
v_GS_COMPUTER_SYSTEM.Model0 as 'PC Model',
v_gs_PC_BIOS.SerialNumber0 as 'Serial Number'

FROM
v_GS_SYSTEM left JOIN
v_GS_LOGICAL_DISK ON v_GS_SYSTEM.ResourceID = v_GS_LOGICAL_DISK.ResourceID left JOIN
v_RA_System_IPSubnets ON v_GS_SYSTEM.ResourceID = v_RA_System_IPSubnets.ResourceID left join
v_GS_COMPUTER_SYSTEM ON v_GS_SYSTEM.ResourceID = v_GS_COMPUTER_SYSTEM.ResourceID left JOIN
v_gs_PC_BIOS ON v_GS_SYSTEM.ResourceID = v_gs_PC_BIOS.ResourceID left JOIN
v_GS_PROCESSOR ON v_GS_SYSTEM.ResourceID = v_GS_PROCESSOR.ResourceID left JOIN

v_GS_X86_PC_MEMORY ON v_GS_SYSTEM.ResourceID = v_GS_X86_PC_MEMORY.ResourceID left JOIN
v_R_System ON v_GS_SYSTEM.ResourceID = v_R_System.ResourceID left JOIN
v_R_User on V_R_system.User_Name0 = V_R_user.Full_User_Name0
JOIN v_FullCollectionMembership fcm on fcm.resourceid=v_r_system.resourceid
WHERE fcm.Collectionid= @Collection

[bdazle]

Resolved with a whole new report .... pasted it here if anyone is keen http://pastebin.com/7vsrGQQd