Reports
Creating, editing and viewing reports within SCCM
259 topics in this forum
-
This report shows all clients which have a advertisement which failed. It is also linked to report 108 (“Advertisement status messages for a particular client and advertisement”) meaning that you can access this report by clicking the link in the first column. This is how it could look: To create this report follow these instructions: 1. Open SMS Console 2. Expand the reporting node 3. Rightclick reports --> New --> Report 4. Enter a name (for example: "All Clients which has a failed advertisement") 5. Enter a category 6. Enter a description 7. Choose "Edit SQL Statement" Insert this code: SELECT a.Name0, b.AdvertisementID, c.Advertisem…
-
- 0 replies
- 4.4k views
-
-
-
Extend "All advertisement for a specific computer" with latest runtime If you want to add a new column with Last Status Time in your SMS Report, fallow the steps below. Expand Site Database, Computer Management, Reporting and mark Reports. Right click on report All advertisement for a specific computer and and choose Properties. Report ID 126. Press on Edit SQL Statement... Replace SQL Statement with the contect below (CODE), press OK. SELECT adv.AdvertisementName, stat.LastStateName, DATEADD(ss,@__timezoneoffset,LastStatusTime) as LastStatusTime, adv.Comment AS C072, pkg.Name AS C062, adv.ProgramName A…
-
- 0 replies
- 7.4k views
-
-
I am currently using this canned report: Report Name: Computers with specific software registered in Add Remove Programs Category: Software - Companies and Products I'm using it to track the installs of our Netbackup client, and it works, kinda. My problem is that im currently rolling out this client to all the servers that don't have it, and it seems to take 15+ hours before this report updates with the new installs. I can't seem to figure out where I need to update the poll/cycle time so that these refresh faster and will show up as registered in add/remove programs. I assumed that it was the software policy but i increased that to update ev…
-
- 3 replies
- 5.5k views
-
