Mike, Have you seen this - https://blogs.technet.microsoft.com/configmgrteam/2012/03/28/building-custom-endpoint-protection-reports-in-system-center-2012-configuration-manager/
Venlig hilsen / Best regards Kent Agerlund Chief Technical Architect @Agerlund Mobile: +45 2616 9054 From: [email protected] [mailto:[email protected]] On Behalf Of Murray, Mike Sent: 9. maj 2016 19:57 To: [email protected] Subject: [mssms] SQL query help? Good morning, Could some help me add the following to this query I am using to pull EP data into Excel? Client: Last Active Time Last Policy Request Last Software Scan Last Hardware Scan User: User Top Console User Existing Query: SELECT v_R_System.Name0 as 'Computer Name', v_GS_OPERATING_SYSTEM.Caption0 as 'Operating System', v_GS_AntimalwareHealthStatus.Version as Version, v_GS_AntimalwareHealthStatus.AntivirusSignatureAge as Age, v_GS_AntimalwareHealthStatus.AntivirusSignatureVersion as DatVersion, v_GS_AntimalwareHealthStatus.LastQuickScanDateTimeStart, v_GS_AntimalwareHealthStatus.LastQuickScanDateTimeEnd, v_GS_AntimalwareHealthStatus.LastFullScanDateTimeStart, v_GS_AntimalwareHealthStatus.LastFullScanDateTimeEnd, v_GS_AntimalwareHealthStatus.LastQuickScanAge as 'Days since last quick scan', v_GS_AntimalwareHealthStatus.LastFullScanAge as 'Days since last full scan' FROM v_GS_AntimalwareHealthStatus INNER JOIN v_R_System ON v_GS_AntimalwareHealthStatus.ResourceID = v_R_System.ResourceID INNER JOIN v_GS_OPERATING_SYSTEM ON v_R_System.ResourceID = v_GS_OPERATING_SYSTEM.ResourceID Best Regards, Mike Murray Desktop Management Coordinator - IT Support Services California State University, Chico 530.898.4357 [email protected]<mailto:[email protected]>
