Skip to content

Reports

Creating, editing and viewing reports within SCCM

  1. Hi, we have a requirement to exclude a particular machine from all the software distributions and updates. Need only the inventory of the machine. How to manage the client through SCCM.

  2. Started by wmmayms,

    I have created a report where you can get a overview of the status of every advertisement in the environment. This can be very useful for getting an overview on how well software distribution is working. When you launch the report you will get the options to choose what status you want to view, for example Failed, Reboot Pending or any other status in your environment. For example you can choose to view all failed advertisements, then the report can look like this: To build this report: 1. Create a new report and give it a good name. 2. Edit the query statement, parse the following code: SELECT AdvState.AdvertisementID, AdvName.AdvertisementName,…

    • 2 replies
    • 9.2k views
  3. Put the below code into a report and run it: SELECT Caption0 as 'Operating System', CSDVersion0, COUNT(*) AS 'Count' FROM v_GS_OPERATING_SYSTEM OPSYS GROUP BY Caption0, CSDVersion0 ORDER BY Caption0, CSDVersion0 Should look something like this: Here is an example on how the report could look =)

    • 2 replies
    • 4.5k views
  4. Started by Jovin,

    Is there a way I can run a report on a collection that I created that list what softwares are installed on the PC on that collection. I'd like to gather information on a collection (department) what version of Lotus notes, Office version, 03' or 07', and version of Mozilla and IE. Thanks,

    • 2 replies
    • 6.1k views
  5. Started by klander,

    Hello guys im new here just wanted to know if this can be done. We have users who have Adobe Acrobat 8 Profesional in our environement. Well i have created a query to show all machines with Adobe Acrobat 8 professional. But what happens is that Adobe acrobat 8 professional will show up even though the user has Adobe creative suite 3 design premium (as adobe professional comes with the package) What i want to achieve to show results of Adobe Acrobat 8 professional, excluding anyone that has Adobe Createive suite 3 design premium. Hope this makes sense.

  6. Started by wmmayms,

    This report will show you all the collections that a specific computer is member of. This is how it could look: To Create this report: 1. Create a new report and give it a good name 2. Paste the following code: SELECT b.CollectionID, b.Name FROM v_FullCollectionMembership a, v_Collection b WHERE a.CollectionID = b.CollectionID AND a.Name = @computer ORDER BY b.name 3. Click on the prompts button 4. Create a new prompt and give it the name: "computer" 5. Enter a prompt text 6. Provide the following SQL Statement: SELECT ResourceID, Netbios_Name0 FROM v_R_System ORDER BY Netbios_Name0 Should look like this: …

    • 2 replies
    • 4.6k views
  7. Started by boognish,

    Any suggestions?

    • 4 replies
    • 5.3k views
  8. Started by wmmayms,

    If you create a report with a prompt you sometimes get more then 1000 results, which means you won´t be able to select all of them since SMS has a limit of 1000 rows. Example (when you click the values button it might look something like this): Here is how to change so you will see all records in the "values" list: 1. Log onto the primary SMS site server or the server that is your reporting server. 2. Go to C:\Inetpub\wwwroot\SMSReporting and take a backup of your file called FilterSample.asp 3. Go to C:\Inetpub\wwwroot\SMSReporting and edit the file FilterSample.asp with Notepad. 4. Search for the below lines (marked in red): 'this is the number of 'Va…

    • 0 replies
    • 3.7k views
  9. Started by The Last Remnant,

    hi there i have a problem when i open any report and run it kindly find below the problem im facing http://img18.imageshack.us/i/13960404.png/ any ideas plz ? thanks

  10. I would like to create a new report by exporting a report as a .MOF, modifying it, and then importing it back into SCCM. Is there a way to generate a new SCCM report from "Reports" -> "import objects"? I have attempted this but have been unsuccessful. I read this can be done by changing the values after "Category =" and "Name =" but it always replaces the previous report. I beleive this is because the ReportGUID stays the same. How can you regenerate a new ReportGUID? Is this possible?? Here is a sample MOF I would like to import as a new report. // ******************************************************************************** * // // Created by…

    • 2 replies
    • 11.6k views
  11. First off I'm a huge admire of this site, it has helped me greatly with my implementation of SCCM2007! Thanks! I hope this is a quick question that can be answered just as quick. I found WSUS reporting a lot more defined in the way that you could tell exactly what updates had been installed (and what hadn't) to specific computer but can't seem to find any reports within SCCM that do the same job. Background - I have created an update list and deployed the updates to controlled test group at the weekend but am finding it pretty difficult to tell what exactly was installed per computer. I managed to find and run the report called 'States 3 - States for a de…

  12. Started by nsilimela,

    Hi there, Is it possible to view SCCM in graphical mode or simply viewing reports using graphs ? if so how ?

    • 1 reply
    • 7.3k views
  13. Started by mike,

    Hello All, I setup SCCM according to the tutorials here. I am unable to connect to the SMSReporting site (http://server_name/SMSReporting_DBName/) from the admin console server. I get the following error when trying to open the site: An error occurred when the report was run. The details are as follows: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Error Number: -2147217843 Source: Microsoft OLE DB Provider for SQL Server Native Error: 18456 On the Reporting server, i am able to get to this page, but nothing loads in on the report side (no error or no report options). I am thinking it is becuase i dont have any type of java installed on the server.…

    • 4 replies
    • 236.9k views
  14. Hello everyone, i'm working on a script which will make complete reportings from SQL. However, i'm stucked in a part of it, being this a 64 bit hexadecimal in a table which represents date and time for the mandatory date. I see a Mandatorysched field but I don't understand the data since it's just a string of characters like "000B49C000080000" - has anybody else had this problem and solved it? I'm making the report tool (actually, a review tool) in VBs. Any help will be much appreciated Regards,

    • 2 replies
    • 5k views
  15. Started by mike,

    Hi, This site is great! Keep up the great work. I am trying to generate a report that will scan the comptuers in the CM and report back if they have a certain software (i.e. Adobe, Symantec, etc). Then, eventually the version and so on. (I am trying to start off small then eventuall grow on the reports). So I created the report below, but it returns an error when ever the % signs are in place. The error that follows when trying to run is : An error occurred when the report was run. The details are as follows: Conversion failed when converting the varchar value 'Adobe PDF Broker Process for Internet Explorer' to data type int. Error Number: -2147217913 …

    • 7 replies
    • 7.6k views

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.