- Edited by Philaitman Monday, September 19, 2011 1:29 PM
Odd Report issue?
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.
September 19th, 2011 1:27pm
Try reproduce this issue with the latest version of Forefront which is System Center Endpoint Protection and if problem reproduced please post it back. There are a lot of improvements in the latest release.
Free Windows Admin Tool Kit Click here and download it now
May 29th, 2015 3:34pm