SSRS Reporting
Question
Hi Team,
We are sending compliance report every month end to all teams. For example – windows , dba etc
Is it possible to add new column name in the report. Is this customisation recommended.
For example
Server name. Team name. Compliance.
Answers ( 9 )
Got it. Thanks
HI,
Everything possible to bring in SQL query except IT owner name.
Because there is no logic behind SCCM to identify which IT owner name is assigned to what computer.
Thanks
Karthikeyan
Hi,
How SCCM can comes to know this computer application owner name is like this name?
Is that any logic which is available in AD?
Thanks
karthikeyan
Hi I do not have much knowledge on this
Initially wanted to confirm whether it’s possible to add owner name in the table and get via report.
I am fine with simple compliance report. But I need to have owner name column
How to feed owner names in views.
Device name
Compliance percentage
Last scan date
Last patched date
Owner name
For example
Server name – xxx
Owner name – windows
Server name – yyy
Owner name – DBA
Server name – xxx
Owner name – IT server
Hi Karthikeyan,
I am looking to have below columns in report.
I need to add column name – owner name.
– device name
Update classification
Critical updates
Security updates
Updates
Definition updates
Feature packs
Service packs
Update roll-ups
Severity
Critical
Important
Compliance
Windows update agent
Version
Software update point
Last scan state
Last scan date
Date last patched
– owner name of the server
Hi,
Yes. Possible to customize your reports based on your requirements. Please share your full requirement.
I will share the SQL query and RDL file.
Thanks
Karthikeyan
Hello Ram, Could you please check the article explained for SSRS Reporting Details!
+https://howtomanagedevices.com/sccm/2168/ssrs-report-creation-configmgr/