PENDING Can I get PowerShell script for Compliance Report

gupta32123

Member
17
1
3
I am looking for the solution where i just need to run a script and my reports for particaular Deployment can come.
 
OP
G

gupta32123

Member
17
1
3
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

Well-Known Member
Staff member
1,127
99
48
What is wrong with using the subscription feature within SSRS to do exactly this?
 

Garth

Well-Known Member
Staff member
1,127
99
48
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

Member
8
0
1
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.
 

Forum statistics

Threads
4,514
Messages
17,668
Members
9,104
Latest member
KoreBreach