PENDING Can I get PowerShell script for Compliance Report

[gupta32123]

I am looking for the solution where i just need to run a script and my reports for particaular Deployment can come.

 

[Prajwal Desai]

Can you give us an example.

 

[gupta32123]

Like I don't want to go to monitoring on daily basis and Generate the Report. I want that if we can Create a PowerShell script in which i can give Collection name and its Deployment name. and it can give me excel sheet in which i can see all the information. Completed, IN progress etc.

 

[Garth]

What is wrong with using the subscription feature within SSRS to do exactly this?

How to Set-up an Email Subscription in SSRS

Send System Center Configuration Manager (SCCM/ConfigMgr) reports by setting-up an email subscription in SQL Server Reporting Services (SSRS).

www.enhansoft.com

Set-up a Windows File Share Subscription

First, you might be wondering, what is a Windows File Share subscription? In SQL Server Reporting Services (SSRS), you can use Windows File Share (WFS) to

www.enhansoft.com

 

[gupta32123]

Yeah, I can Use this, But I was just trying to get some other way to make it automate.

 

[Garth]

Yeah, I can Use this, But I was just trying to get some other way to make it automate.

But the Subscription methods is automated. At the end of the day this is NOT a CM question but and SSRS / PowerShell question.

OR

Just use Excel to query SQL directly to create the reports that you are looking for.

 

[simon_berg]

Well actually you could take this a step further and create a connection to your SCCM database from PowerBI an report on the data in many ways.