Stage Windows Feature Report
I'm sending the Windows Feature Package for some devices by Detect and Stage Option. I'm also trying to get a report to see the progress without success.
Does anyone have some SQL query to get it?
This is the closest attempt. The Table OSUPGRADE_MACHINE_REMEDIATION_STATUS does not have the information I'm looking for.
SELECT M.OS_BUILD, M.OS_RELEASE, M.BIOS_SERIAL_NUMBER, M.NAME,
FROM OSUPGRADE_MACHINE_REMEDIATION_STATUS MS
JOIN KBSYS.OSUPGRADE PP ON PP.ID = MS.OSUPGRADE_ID
LEFT JOIN MACHINE M ON M.ID=MS.MACHINE_ID
ORDER BY PP.TITLE
I found a workaround by myself. I created a Custom Inventoty Rule with this command:ShellCommandTextReturn(cmd /c dir C:\ProgramData\Quest\KACE\kpd\*.esd)
The result is like:
After that, I created a wizard report with this Custom Column. I know this is not the solution, but meanwhile helps me to get the information
Any better idea?