Client Management Suite

Is there a report that I can look at that will tell me what patches have been installed on my clients the night before? I used to use the Restart status report in 7.0 to show me the patches that were installed. It was nice as it showed the patches that needed a restart as well as the ones that did not.

The restart status report was changed in 7.1 and it only shows the patches that DO require a reboot. So this report isn't giving me all the information I'm looking for.

Does anyone know of a report that will show me all the patches installed the previous night? I want to come in and check the report in the morning and see exactly what was installed the previous night's maintenance window. If I could then put this into an automatted email to be sent to me each morning that would be even better.

Thanks

Larry

No one knows of a patch report that will show the patches installed the previous night?

Patch Management Reports are in All Reports  => Reports => Software => Patch Management

but you can create a sql report, we run a sql report on the software installation during a day.  So we can see all the installation.

That sounds exactly what I'm looking for. Could you post the SQL query you run for the software installed?

select*

from Inv_AeX_SWD_Execution_Summary, Inv_AeX_AC_Identification

where Inv_AeX_SWD_Execution_Summary._ResourceGuid = Inv_AeX_AC_Identification._ResourceGuid and Domain = 'of' and _eventTime >='2011-10-07 01:00:00.000' 

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