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.

 

solved 0
ram kumar 2020-05-31T09:50:36+05:30 9 Answers 179 views Beginner
0

Answers ( 9 )

  2. ram kumar
    0
    2020-06-03T13:55:54+05:30
    Reply

    Got it. Thanks

  4. karthikeyan
    0
    2020-06-02T19:13:43+05:30
    Reply

    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

    Best answer
  6. karthikeyan
    0
    2020-06-02T16:04:31+05:30
    Reply

    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

    • ram kumar
      0
      2020-06-02T17:45:09+05:30
      Reply

      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.

  8. ram kumar
    0
    2020-05-31T18:14:18+05:30
    Reply

    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

  10. ram kumar
    0
    2020-05-31T18:03:38+05:30
    Reply

    For example
    Server name – xxx
    Owner name – windows

    Server name – yyy
    Owner name – DBA

    Server name – xxx
    Owner name – IT server

  12. ram kumar
    0
    2020-05-31T16:55:06+05:30
    Reply

    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

  14. karthikeyan
    2
    2020-05-31T11:50:41+05:30
    Reply

    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

  16. Jitesh Kumar
    1
    2020-05-31T10:55:55+05:30
    Reply

    Hello Ram, Could you please check the article explained for SSRS Reporting Details!

    +https://howtomanagedevices.com/sccm/2168/ssrs-report-creation-configmgr/

Leave an answer

Sorry, you do not have permission to answer to this question .