• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1423
  • Last Modified:

How to output report for baseline in sccm 2012

I have setup a baseline to show all system that have a particular registry entry.

How can I output the list to an csv or xls file?
0
rdefino
Asked:
rdefino
  • 3
  • 2
1 Solution
 
merowingerCommented:
Are all those "compliant" Clients within a Collection?
0
 
rdefinoAuthor Commented:
Not sure. We have about 5 collections, so they could be mixed amongst the collections. Do matter that they could be in different collections?
0
 
merowingerCommented:
You can create a query rule for a collection which contains all System which are compliant with your baseline.
Afterwards you can easily export the memberc of the collection

The query would be as following:
select *  from  SMS_R_System inner join SMS_G_System_CI_ComplianceState on SMS_G_System_CI_ComplianceState.ResourceId = SMS_R_System.ResourceId where SMS_G_System_CI_ComplianceState.ComplianceStateName = "Compliant" and SMS_G_System_CI_ComplianceState.CI_UniqueID = "[b]YourBaselinesScopeID[/b]"

Open in new window


To get the ScopeID of yourbaseline, in SCCM Console goto you "configuration baselines" and add the column "CI Unique ID" to the view. Then you can use the ID in the query
0
 
rdefinoAuthor Commented:
Where do I create the query rule. I cannot edit memeber rules in "all systems"
0
 
merowingerCommented:
You have to create a new collection and leave the "All Systems" collection untouched
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now