Hi Larry
for software reports, I use following sql for the automation policy that runs on a daily schedule:
SELECT mt.Name as [Computer Name], mt.[OS Name] as [OS], m.AdvertisementName as [Software Resource/Task that were executed], (u.Domain + '\' + u.[User]) as [Primary User], m.Status, m.ReturnCode, m._eventTime as [Event Time]
FROM Inv_AeX_SWD_Execution_Summary AS m LEFT JOIN
Inv_AeX_AC_Identification AS mt on m._ResourceGuid = mt._ResourceGuid LEFT JOIN
InV_AeX_AC_Primary_User AS u on m._ResourceGuid = u._ResourceGuid
WHERE (LOWER(m.Status) NOT LIKE LOWER('%Fail%')) AND (CONVERT(varchar(10), m._eventTime, 120) >= CONVERT(varchar(10), GETDATE() - 1, 120)) AND
(CONVERT(varchar(10), m._eventTime, 120) <= CONVERT(varchar(10), GETDATE(), 120))
This will give you the Software that were installed in the last 24 hours (time from when the automation policy runs). It will give you just the software that were not failed as you see in the query "NOT LIKE LOWER('%FAIL%')"
I use 2 automation policies for this. 1 for failed software, and the other for successfully installed. (Just remove NOT if you wish to display failed software installations)
Report will display this: Computername, OS, Software Advertismentname, PrimaryUser, Status, Returncode and the Eventtime
Hope this helps
Cheers
Patrick