Does anyone have a sql report query for manage install details view
I want to display a report like manage install detail when show all manage install task, and add a column for installed date. I tried to find the table but haven't found it yet
So "install date" is a bit tricky: it doesn't exist in the tables "MI" nor "MI_ATTEMPT". AFAIK, the only way to get a good idea of the actual "install date" is to use asset history to see the first time an app was detected. However, you only retain that information if you configured the settings in "Settings" > "History" > "Assets" (under "Subscriptions) > "Computer"
That being said, here's a query that will get you some of the info:SELECT
S.DISPLAY_NAME as "SOFTWARE_TITLE",
WHEN J.SOFTWARE_ID IS NULL THEN 'NOT INSTALLED'
END AS 'STATUS',
MI ON MI.ID = A.MI_ID
MACHINE ON A.MACHINE_ID = MACHINE.ID
SOFTWARE S ON S.ID = MI.SOFTWARE_ID
MACHINE_SOFTWARE_JT J ON J.MACHINE_ID = MACHINE.ID
AND J.SOFTWARE_ID = MI.SOFTWARE_ID
MI.ENABLED != 0