I have the need to quickly report on the servers that have non-compliant resources within our 5000+ server environment. I see that there is an "AdditionalData" column added in v5.1 that contains a bunch of stuff I don't really care about 🙂 Is there any way of sending additional "custom reporting data" to populate AdditionalData, or any other column for that matter, with? Or has anyone achieved this using a different method?
We don't use the Report Server here; I have a script that uses Invoke-Command to run Get-DscConfigurationStatus on each machine overnight. It checks a number of aspects of the results, including:
-Did the last check run recently? (StartDate)
-Are there resources not in the desired state? (ResourcesNotInDesiredState)
-Were there any errors in the last run? (Error)
-Does the overall status = Success? (Status)
-Was the correct config applied, as per our config db? (MetaData)
I don't parallelize it (we don't have that many servers), but that would be easy since I'm using Invoke-Command. But if there's a way I can get the report server to tell me all that without my having to query each host, I'd love to hear about it.
I'm glad I'm not the only one looking to get this data!! With that being said, the only thing the reporting server is lacking out of what you want is ResourcesNotInDesiredState, which is exactly what I want 🙂 Everything else is available. I really don't know why they wouldn't, by default, report back what wasn't in the desired state.