abhatem
10/07/2020, 5:54 AMalessandrogario
abhatem
10/07/2020, 12:29 PMfritz
10/07/2020, 5:49 PMSELECT
MAX(CASE WHEN key = 'InstallDate' THEN value END) AS install_date,
MAX(CASE WHEN key = 'AllocatedBaseSize' THEN value END) AS allocated_base_size,
MAX(CASE WHEN key = 'Name' THEN value END) AS name,
MAX(CASE WHEN key = 'Caption' THEN value END) AS caption,
MAX(CASE WHEN key = 'Description' THEN value END) AS description,
MAX(CASE WHEN key = 'CurrentUsage' THEN value END) AS current_usage,
MAX(CASE WHEN key = 'PeakUsage' THEN value END) AS peak_usage,
MAX(CASE WHEN key = 'TempPageFile' THEN value END) AS temp_file_page
FROM kolide_wmi
WHERE class = 'Win32_PageFileUsage'
AND properties = 'Caption,Description,InstallDate,Status,AllocatedBaseSize,CurrentUsage,Name,PeakUsage,TempPageFile'
abhatem
10/08/2020, 5:12 AM