Month: May 2009

Report including the AD Display name

Select DISTINCT     sys.Netbios_Name0,     fcm.SiteCode,     sys.User_Domain0,     sys.User_Name0,     sys.Operating_System_Name_and0,     arp.DisplayName0,     ru.Full_user_Name0 FROM     dbo.v_R_System sys     JOIN dbo.v_Add_Remove_Programs arp ON sys.ResourceID = arp.ResourceID     JOIN dbo.v_FullCollectionMembership fcm on sys.ResourceID=fcm.ResourceID     join dbo.v_R_User ru on sys.User_Domain0 = ru.Windows_NT_Domain0 and sys.User_Name0 = ru.user_name0 WHERE     DisplayName0 = @displayname     and fcm.CollectionID=@CollID