Skip to content

Reports

Creating, editing and viewing reports within SCCM

  1. Started by Petersburg_man,

    Hello! Please, sorry for my English. It isn't as well, as possible:) How can I get the language of installed OS? In our organization we are using both Windows 7 and Windows XP. Win7 is only English, but WinXP is not only English, but Russian also. It is nesessary to get information of OS's language. And, of course, I'd like to get type of installed OS. For example, Win7 has such types as Enterprise, Professional and so on. So, how can I get them?

  2. Started by thadkew,

    Is it possible to create a report to see if a particular folder exists on a client PC? We're trying to find out if the PC has a folder called "Software 1" Then we'll match that to a report that checks to see if it has a folder called "Software 2" and eventually flag the ones that have both. Possible?

    • 0 replies
    • 3.2k views
  3. Started by paddy,

    Hi there, I am fairly new to SCCM and I looking for some help on the reporting aspect of this tool. I have been assigned the task of removing unused versions of MS Visio and MS Project. I have ran reports on what versions etc are in add/remove programs on network. I want to identify the last time they were last used via software metering reports but there doesnt appear to be any software metering rule for visio or project. Are there any step by step guides to perform this? I have tried adding software metering rule but it doesnt appear to be reporting back anything. Any help would be great.

  4. Started by fcurrito,

    Dear all, I am new to SCCM 2007 R3 and need to do some integration. I have access to the views in the underlying database and need to know which views to mapp to in order to extract the data on all the software applications installed on client PCs and servers. I managed to downlaod all the data related to PCs and server but need to the software part. I am loooking at v_GS_ADD_REMOVE_PROGRAMS view, but it has hardly any data in it, I mean apart from some 4 usefull columns, namely Display name, version, product name and some IDs. Is there any other view(s) I can join this with to get any other avaialable information on SCCM on all the software application in…

  5. Started by FunnyStar,

    Hi, I followed the below link for patch compliance report. I would like to add some additional information in these report as Patch install date from Add remove program list to this 3rd report. Can anyone help me out to get this report. http://eskonr.wordpress.com/2010/03/25/monthly-patch-statistics-reports-to-show-up-to-the-management-in-a-simplified-manner/ Thanks in advance.

  6. Hi, I was wondering how possible it was to create (or edit) a report which lists results in the format of License Report 01A (the MS License Ledger one), but gathers data simply from the Installed_Software asset intelligence class? Basically so I can query on all software (and maybe filter on software vendor LIKE %microsoft% ??) and count all the MS applications that SCCM has detected...? Cheers, MRaybone.

  7. Started by Mr Ricky,

    Hello all, I have never used SQL before, just started using SCCM 2007 with 1 site and multiple Distribution Points. We are a windows XP shop with Office 2007 in the process of upgrading all Laptops & Desktops from Symantec AV to MS Forefront. 1) I would like to run a report that shows me all the machines running forefront and which machines are still running Symantec AV. 2) I would like to run a report that shows me all Computer Names, Specs (Hard Drives, Memory),Serial numbers and logon user. If possible, steps by steps instructions on how to use the Query etc... will be verhy helpful. Thank for your help,

  8. Started by jtbenn,

    Is there a way to clear old advertisement report info without having to delete the advertisement and recreate it? We are doing migrations from GroupWise to Outlook and we are doing 15-20 at a time. We have several different computer makes and models and I like to keep track of just what we are doing on a given night and having all the old info in the reports gets in the way. I would like to be able to clear it out each night before we kick off another round. A right click solution would be awesome. Thanks James

  9. Started by mike,

    Hello, I am trying to create a report that will prompt to enter an AD boundary then once runned it will count the clients and list some system resources. I have gotten to runing a query on the entire AD site with the system resources needed be listed. SELECT a.Netbios_Name0, a.User_Name0, a.Operating_System_Name_and0, a.AD_Site_Name0, b.IP_Addresses0 From v_RA_System_IPAddresses b, v_R_System a WHERE a.ResourceID=b.ResourceID But now I want to query say boundary 2 only and not the entire listing. I have tried using the 'count' command with no success and also the v_SiteBoundary_ADSite view with column ADSiteName. but couldnt find a relation w…

    • 0 replies
    • 3.4k views
  10. Started by cheef116,

    I'm new to SCCM and SQL and I'm trying to figure out how to create a custom report that will display Netbios Name, MAC Address, and Serial Tag for all systems. Can anyone help me out?

  11. We have both versions of MS Office in our environment and getting ready to deploy Outlook, however we have older machines with 512MB RAM and a few that's below that. The problem is that I need to identify those machines with less than 512MB and Office 2003 and do it by location, there are 22 Distribution Points and would like to use those as the location. I need to create this report that list the following items: 1. Machine name 2. Machine Type - Model 3. Amount of memory 4. Operating system - We have XP, Vista Business x64 and now a few Windows 7 5. Microsoft Office version (2003 and 2007) 6. Service Packs version for Office.

    • 5 replies
    • 5.8k views
  12. Dear All I am trying to run reports to view X software in Add/Remove Program, the result was that some deleted software appear in the reports and same from Resource Explorer can I know why ?? also I tried to push patch file "MsiExec.exe /X{XXXXX-XXXXX-XXXXX-XXXXX-XXXXX} REBOOT=RealySuppress /qb-!" to uninstall X Software from machines, all machines received the patch but unfortunately didn’t remove it :angry: , I need your advice about these issue please.

    • 4 replies
    • 9.8k views
  13. Started by kfv7,

    Hi, I am new to this forum. I have a problem, i have to make a report in SCCM 2007 and I dont know SQL. I have made the following one copying from others ones. declare @Total int declare @Succeeded int declare @Failed int declare @InProgress int select @Succeeded = count (*) from v_ClientDeploymentState where DeploymentEndTime is not NULL select @Failed = count(*) from v_ClientDeploymentState where LastMessageStateID>100 AND LastMessageStateID<400 select @InProgress= count(*) from v_ClientDeploymentState where DeploymentEndTime is NULL and LastMessageStateID = 100 select @Total = @Failed + @InProgress + @Succeeded if @Total > 0 begin …

    • 0 replies
    • 3.7k views
  14. Started by Ariel,

    I'm new to SCCM 2007 r2 and SQL express in the same box and I'm trying to figure out how to create a custom report that will display VLAN,Netbios Name, MAC Address, and Serial Tag for all systems in my domain. Can anyone help me out?

    • 1 reply
    • 4.2k views
  15. Hello, i read my SCCM 2007 Book, search many in the WWW und try out Something but the results are not okay. Can anyone explain me how i make a easy query to find out How many Office 2000 / XP / 2003 / 2007 are installed in my Domain. All clients have the actually Agent installed but not all Systems are installed with SCCM, we have changed our Installation System Server from SYMANTEC LSD to SCCM 2007. Thank. with best regards André Jansen

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.