PENDING CMPivot Query for deployments summary for last month

[psanaga]

Hi,
I have a quick question abt CMPivot query for the number of deployments.
Eg: 1 device was patched with 5 different patches equals 5 deployments

I am looking for a query which will provide a summary of deployments for last month

Thanks.. Pratap

 

[Garth]

Hi,
I have a quick question abt CMPivot query for the number of deployments.
Eg: 1 device was patched with 5 different patches equals 5 deployments

I am looking for a query which will provide a summary of deployments for last month

Thanks.. Pratap

CMpivot is not the right tool to answer this, instead you want to query the database. Start by looking at the built-in reports.