:bump:
From: [email protected] [mailto:[email protected]] On Behalf Of Murray, Mike Sent: Monday, May 9, 2016 10:57 AM 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 <mailto:[email protected]> [email protected]
smime.p7s
Description: S/MIME cryptographic signature
