Skip to content

Reports

Creating, editing and viewing reports within SCCM

  1. Started by jheideman,

    I was wondering if there was a report that would allow me to see printers that are loaded on computers in our Domain. I followed the instructions from (http://geekshangout.com/?q=node/41. I opened the sms_def.mof file, and set the SMS_Report to true for Printer Devices. I also went through and enabled a few of the items below it (Driver name, Location, portname, name, etc). After making these changes I created a report, but every time I run it I get the following error message (Invalid object name 'v_GS_PRINTER_DEVICE'.) Any tips or advice would be greatly appreciated

  2. I have looked around but not found anything and I'm not great with the reports. I'd like to find a list of servers/clients that don't have a page file on the OS drive in case of a BSOD. Has anyone created anything like this?

  3. Started by mike,

    Hello, Can someone assist me with modifing SCCM Report ID 66? The statement for Report ID 66 is: Select SYS.Netbios_Name0, SYS.User_Name0, SP.ProductName, SP.CompanyName, SP.ProductVersion FROM v_GS_SoftwareProduct SP JOIN v_R_System SYS on SP.ResourceID = SYS.ResourceID WHERE SP.ProductName = @variable AND SP.ProductVersion = @variable1 Order by SP.ProductName, SP.ProductVersion I want to add the computer's serial number into this statement. This is what I have: SELECT v_R_System.Netbios_Name0, v_GS_PC_BIOS.SerialNumber0, v_R_System.User_Name0, v_SoftwareProduct.ProductName, v_SoftwareProduct.ProductVersion, v_SoftwareProduct.CompanyName FROM v_R_S…

    • 1 reply
    • 5.3k views
  4. Started by Vancouverite,

    With R3 and power management set up, are there any reports that can be ran to show what time a computer went to sleep, when it woke up, how much time was spent in the sleep state, etc? The built-in reports only seem to show if a given machine is powered on or if there is user activity, regrdless of whether it is awake or asleep.

    • 0 replies
    • 2.8k views
  5. I've upgraded my site to R3 and pushed out the hotfix for R3 to s small test group of users in our department successfully along with enabling power management on my site under site management/site settings/site systems/site-name I am able to run pre-R3 reports but when i went through a tutorial to setup power management reporting, there is a further option under computer management/reporting/reporting services that I am missing and don't know how to add http://scug.be/cfs-file.ashx/__key/CommunityServer.Blogs.Components.WeblogFiles/sccm/image_5F00_0B5D1F54.png My site does not have the redded-out server-name under the reporting services...nor is there an opti…

  6. Started by bu7ch,

    I recently realized that some of our computers have long names (>15 characters). Is there a way to determine or query how many computers have a name that is greater than 14 characters?

  7. Started by yalsoufi,

    Hi This is my first post on your website Please I would like to know how may I create a coustom report List All PC's with there Monitor deatiles Monitor Serial# ,Manufacture etc ,,, so may you help me please

    • 1 reply
    • 9.8k views
  8. Started by cduplessis,

    Hi All, We have some workgroup clients, with the same hostname, natt'ed IP addresses. I now need to determine which machine is where. A script has been created to populate the computer description field. Can I run a report that will return the hostname, model, hd size, memory serial numbers as well as the computer description. The report I have returns all the values Except the Computer Description. Thanks in advance Carlo

    • 0 replies
    • 3.2k views
  9. Started by KeithDib,

    Hi Is is possible to deliver software to a collection but have a select few machines that do not recieve the application? Thanks Keith

    • 0 replies
    • 3k views
  10. Started by KeithDib,

    Hi all Is there a report that will just show machines that have recently had the client installed? If there is not default report does anyone have a custom report they can share Thanks Keith

  11. Started by krishnamoorthy,

    Hi All, I have created the report for over all patch summary based on the below query. select summ.ID,summ.title,summ.QNumbers as 'Q Number', COUNT(distinct ps.ResourceID) as 'Requested', COUNT(distinct case when ps.LastState=107 or ps.laststate=102 or ps.laststate=105 then ps.ResourceID else NULL End) as 'Installed', ROUND(100.0*COUNT(distinct case when ps.LastState=107 or ps.laststate=102 or ps.laststate=105 then ps.ResourceID else NULL End) /count(distinct ps.ResourceID),2) as 'Success %' from v_GS_PatchStatusEx ps join v_ApplicableUpdatesSummaryEx summ on ps.UpdateID=summ.UpdateID where (summ.Type='Microsoft Update') group by sum…

  12. Does anyone know if it is possible to report on all aspects of a package, program, and advertisement in SCCM? A report showing the properties of packages, programs, and advertisements used for the purpose of documenting the packaging process. Source directory, command line, run from DP, all the tabs and options in a program and advertisement.

  13. Is there any possibility to make a report or just run one that could say if a deployment succeeded or not. I'm asking because a client wants to know if the 100 machines he staged have installed correctly every application.

  14. I met Garth Jones (ConfigMgr MVP) at the Global MVP Summit in Seattle and I heard about Ehansoft and one of the cool things they are doing is giving away reports every month, Garth is a very nice guy so return the favor and see what's on offer over there, want a cool report ? check it out - and vote - http://support.enhansoft.com/Forum/default.aspx?g=posts&t=29

    • 0 replies
    • 2.9k views
  15. Started by peled,

    Hello all Soon, we will start moving to Windows7. I have built in report for Windows7 Assessments (Code attached). I need to add to the report, few more datiales about computers: OU of the computer account in the AD. Last logon Username Last hardware scan date Can enyobe assist with this? Thanks Peled Threport Code: SELECT DISTINCT SYS.Netbios_Name0, fcm.SiteCode, OPSYS.Caption0 AS 'Operating System', OPSYS.Version0 AS 'Version', OPSYS.CSDVersion0 AS 'Service Pack Level', CASE WHEN (OPSYS.Caption0 LIKE '%Server%') OR (OPSYS.Version0 < '6.0.6001') OR (OPSYS.Version0 = '6.0.6001' AND OPSYS.CSDVersion0 < 'Service Pack …

    • 5 replies
    • 6.3k 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.