I'm attempting to gather data on the gaps in our coverage for a specific System Center Agent on our Windows servers. We're running the latest patch on Istanbul. SNOW has this data, but I can't expose it correctly. I'm able to return where the a...
Hello, I would like to make a report once and use it across orgainztions in my company.I would like for the condition/filter on the organization to be selectable by the user instead of hard coded in the report...At this point I have to create the s...
I've been trying to create a database view where I can see what groups are assigned to (fulfillers) in various workflow activities (catalog task, approval, etc). Basically show an assignment group and then show the workflow (workflow version), the ...
I've tried using the table dictionary, but the results are null, so I'm at a bit of a loss what to try next...
We are trying to get the class type as a breakdown in computer table but all the different class types are further extensions. Is there any way to create a breakdown source to get "Class" to get all the types in computer table?
I am trying to create a report that shows open and closed incidents by assignment group for the last month. I am still new to reporting and performance analytics and cannot seem to get the information I need in one report. We do have performance anal...
When reporting on the sys_attachment table how can i tell which record it is attached to?I have a filter condition: table is cmdb_ci_serviceBut with the available column fields I can only get 'File Name' this is of any use, none of which tell me whic...
I created a manual breakdown :I associated it to and automated Indicator but nothing comes out. I see the Breakdown elements but nothing came out:I need to no know if is possible to associate a manual breakdown to an automated indicator or not?
I want to be able to generate group totals and display them to users so that they can extract the aggregates as values. Example:Group CMDB_CI by Class, reporting the COUNT of rows in each class.If I do this with a Line report, SN displays the Group...
Hello,I have a Project A that has Project Task1, Project Task 2, and Project Task 3. I then have time cards against these 3 project tasks.I also have Project B (with no project tasks) and time cards against Project B.How do I create 1 report to pull ...
I have created a report from Approval [Sysapproval_approver] table. I want all comments including history comments only for change requests. I have tried adding filter using sysapproval_approver where starts with CHG% but that doesn't work to only ge...
Hi all, I have a problem with performance analytics. I have to create an indicator for average survey score. Really simple scenario: 1. Indicator source on Metric Result (asmt_metric_result), 2. 2 automated indicators based on this source, one for su...
I am trying to run a report on Requested Item that will show me the child Catalog Task. I know I can run it the opposite way with Catalog Task to show the parent RITM, but I don't want to run it that way. I believe we have a problem in our system w...
So, I have a bit of a conundrum. We've created a separate ticketing module called Construction Engineering. It functions like the Incident module, but is set up like the Request module. (Not sure why, this was before my time...) We've recently had to...
