Menu
CCMEXEC.COM – Enterprise Mobility
  • Home
  • General
  • Configuration Manager
  • Windows 10
  • Intune
  • GitHub
  • Windows 11
  • About the author
CCMEXEC.COM – Enterprise Mobility

Tag: SCCM Reports

SCCM 2007 Report: Windows 7 computers without SP1

Posted on December 7, 2011December 13, 2011 by Jörgen Nilsson

Hi, Answered a question on Technet forum this morning and about a report to list all Windows 7 computers without Service Pack 1 installed. I modified it slightly for this post to include the possibility to filter on a specific collectionID. When creating the report create a prompt in the report called varcollection Report Query: Select…

+

Report: Advertisement status for a specific adv. and collection part 2

Posted on June 12, 2010 by Jörgen Nilsson

As a follow up and as I  promised in a previous post here are both reports which makes it possible to track advertisement status per collection and to link it to the next report, All system resources in a specific collection for a specific advertisement in a specific state. These both reports makes it possible…

+

Report: Advertisement status for a specific adv. and collection.

Posted on May 29, 2010May 29, 2010 by Jörgen Nilsson

Another report ;-)! There are many scenarios where I found that it would have been great to be able to track advertisement status for a specific advertisement per collection. For instance, if a manager places a service request that 40 computers at that department should have Office 2010 installed, it would be great to have a report showing the result per collection.     …

+

SCCM Report Count Computer models per collection

Posted on April 27, 2010June 1, 2010 by Jörgen Nilsson

This reports will help you plan you roll-out project and plan it by presenting a report with a count of each computer model per collection. If you already have collections in SCCM per site, per department, per subnet or whatever you wan’t, you can use them to report which models exist. The reports can be…

+

Adding Serial Number to the “Computer information for a specific computer” report

Posted on April 8, 2010 by Jörgen Nilsson

I got this request from a customer and thought I could share it. Below query describes how to modify the query for the built-in report “Computer information for a specific computer” to include serial number.  The added sql commands are marked in red color if you want to change it yourself instead of copying the SQL…

+

My name is Jörgen Nilsson and I work as a Senior Consultant at Onevinn in Malmö, Sweden. This is my blog where I will share tips and stuff for my own and everyone elses use on Enterprise Mobility and Windows related topics.
All code is provided "AS-IS" with no warranties.

Recent Posts

  • Community tools demoed at WPNinjas 2023
  • PowerShell script to keep Personal Teams away in Windows 11
  • Windows 11 Multi-App kiosk – a first look
  • Playing around with Driver Updates in Intune
  • MMUGSE – Summer Meetup 8th of June 2023

©2023 CCMEXEC.COM – Enterprise Mobility | WordPress Theme by Superb Themes
This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish.Accept Reject Read More
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT