I've created a report (Or plagiarised the idea from someone here) I can't remember which... Which shows the Last boot, Last user, device and Ou name for Devices in the Deployment Pending Collection. This works great.  However if i use the same query and change the collection it's pointing too, to the 'Locally removed' ITS00015 at our site. The query returns no data. Could someone check this out? Is it a problem with my query? This works great if I change the Collection ID to ITS00014 (Deployment pending) YES I have checked there are devices in Locally removed ;0) SELECT     TOP (100) PERCENT dbo.v_R_System.Netbios_Name0, dbo.v_R_System.User_Name0, dbo.v_GS_OPERATING_SYSTEM.LastBootUpTime0,                        MAX(dbo.v_RA_System_SystemOUName.System_OU_Name0) AS [OU NAME] FROM         dbo.v_GS_OPERATING_SYSTEM INNER JOIN                       dbo.v_R_System ON dbo.v_GS_OPERATING_SYSTEM.ResourceID = dbo.v_R_System.ResourceID INNER JOIN                       dbo.v_RA_System_SystemOUName ON dbo.v_GS_OPERATING_SYSTEM.ResourceID = dbo.v_RA_System_SystemOUName.ResourceID INNER JOIN                       dbo.v_CM_RES_COLL_ITS00015 ON dbo.v_RA_System_SystemOUName.ResourceID = dbo.v_CM_RES_COLL_ITS00015.ResourceID GROUP BY dbo.v_GS_OPERATING_SYSTEM.LastBootUpTime0, dbo.v_R_System.User_Name0, dbo.v_R_System.Netbios_Name0 ORDER BY dbo.v_R_System.Netbios_Name0, MAX(dbo.v_RA_System_SystemOUName.System_OU_Name0) We didn't put a prompt in there as the report is for non sccm savvy users who don't know our collection structure.

• Edited by Philaitman Monday, September 19, 2011 1:29 PM