SQL Query to display CA Patch Me Rollup deployment succusfully installed machines .

Products

• CA Client Automation - IT Client Manager

Issue/Introduction

CA Patch Me deployed  and  successfully installed on many machines . Use below SQL query If you want to know on how many machine its installed sucessfully .

Environment

Release : 1403

Component :

Resolution

Execute the below query in SQL Query Analyzer . Change the patch me v2105 to different month based on your requirement. 

SELECT M.agent_name [Computer Name],
R.itemname [Package Name],
R.itemversion [Package Version],
P.itemname [Procedure Name],
dateadd(ss, completiontime+ datediff(ss,getutcdate(),getdate()), convert(datetime,'19700101')) [Install Time]
FROM usd_applic A
LEFT JOIN usd_actproc P ON A.actproc=P.objectid
LEFT JOIN usd_rsw R ON P.rsw=R.objectid
INNER JOIN ca_agent M ON A.target=M.object_uuid
WHERE R.itemname like 'UPM - CA - Patch Me - Security IntelliRollup v2105.00%' and A.status=9 and P.itemname='Silent Install' and A.uninstallstate<>2
ORDER BY [Computer Name], [Install time]

Result Will be Displayed as below: