tag:blogger.com,1999:blog-59220580740882360832024-03-21T14:18:15.411+01:00Configuration Manager and Custom Reports for Configuration ManagerWelcome to my Configmgr and Configmgr Reporting Blog, here I will share some of my custom reports for Configmgr 2012/Current Branch with description on how to adapt them to your environment. I'll also post some general Configmgr stuff and some tips and tricks for report buildingAnonymoushttp://www.blogger.com/profile/18346125655776046808noreply@blogger.comBlogger27125tag:blogger.com,1999:blog-5922058074088236083.post-55010871730351506922017-05-19T11:53:00.000+02:002017-05-19T13:42:38.073+02:00WannaCry Patch Report - Follow Up PostCrazy week huh?
The interest for Software Updates went from close to zero to a hundred over a weekend and suddenly you have managers demanding status reports on how well their're department are patched against WannaCry.
Normally when i create reports I use them myself for some time (sometimes months or years if i forget about it) to work out all most of the bugs before i release them.
Since Anonymoushttp://www.blogger.com/profile/18346125655776046808noreply@blogger.com34tag:blogger.com,1999:blog-5922058074088236083.post-34450024641291880652017-05-15T12:46:00.002+02:002017-06-29T10:33:32.427+02:00WannaCry Patch Compliance Report
15 May 13:40 ,Updated the query to show Windows 10 (Build 15063) creators Update as Patched
15 May 14:10, Had made a mistake in the last version ,with the update status. fixed now.
15 May 15:00 Expanded the list of updates.
16 May 10:00, This doesn't work as expected ,when a update is superseded the old one is set as "Not Requered". Got a new version almost ready that uses Baseline/CI Anonymoushttp://www.blogger.com/profile/18346125655776046808noreply@blogger.com62tag:blogger.com,1999:blog-5922058074088236083.post-9008476667885844782016-10-23T12:13:00.001+02:002016-10-23T22:22:08.461+02:00Creating Report SubscriptionsSmall followup post to the report i released yesterday
The reason i released that particular report is that i saw a discussion somewhere (Reddit or the winadmins slack) on that people outside the Configmgr team never use reports or any other means of staying updated on how well the clients are managed.
I can understand that for a sysadmin/manager that don't work with Configmgr on a daily basis Anonymoushttp://www.blogger.com/profile/18346125655776046808noreply@blogger.com10tag:blogger.com,1999:blog-5922058074088236083.post-60959047950409713962016-10-22T17:03:00.002+02:002016-10-22T17:16:59.216+02:00Collection Summary Report ,3 in one Report! (Windows Update ,Endpoint Protection ,OS and Computer Model)Finally got around to tweaking and translating my "Collection Summary" Report.
I created this report to replace several other reports that i force feed our site admins on a weekly basis:-)
The report is designed to be an e-mail report, sent out once a week that gives them a quick overview of whats going on at their site(collection).
This report have 3 sections ,Computer Details(OS,Model and Anonymoushttp://www.blogger.com/profile/18346125655776046808noreply@blogger.com42tag:blogger.com,1999:blog-5922058074088236083.post-48914978299682556822016-09-12T14:49:00.002+02:002017-05-02T19:00:14.527+02:00Windows 10 - Editions and Versions Report (in lack of a better name)
Hi
May 02: Quick Update ,seems to be a small "bug" with how Windows 10 1703 (Creators Update) registers in Configmgr DB. For some reason the "branch" field is a empty string, not 0 as expected (or at least NULL instead of empty string).have created a new version of the report (Download it here) as a work around for this issue.
Created this report a few months ago, but didn't release it becauseAnonymoushttp://www.blogger.com/profile/18346125655776046808noreply@blogger.com30tag:blogger.com,1999:blog-5922058074088236083.post-42901377113199559342016-09-02T14:40:00.000+02:002016-09-02T14:40:37.066+02:00Distribution Point Reports ,Bonus ContentGot a question under the blogpost for my distribution point reports about a "Content View". Basicly a list of packages with colums for each Distribution point.
When i created the Distribution Point Reports i actually had this type of view in the early versions of the reports ,but I didn't include it in the final version.
So if someone else find it usefull ,here it is. I've Anonymoushttp://www.blogger.com/profile/18346125655776046808noreply@blogger.com4tag:blogger.com,1999:blog-5922058074088236083.post-29777792415562619292016-06-29T20:56:00.003+02:002016-06-29T21:15:48.414+02:00v_GS_OPERATING_SYSTEM not updating correctly
I'm working on my Windows 10 Report ,but i've run into a strange problem and i'm wondering if anyone else sees the same thing.
The problem seems to be that v_GS_OPERATING_SYSTEM SQl view is not updating correctly. lots of machines that have been upgraded to Windows 10 still show their old Operating system.
v_r_System seems to be correct and i have verified that the machines are running windows Anonymoushttp://www.blogger.com/profile/18346125655776046808noreply@blogger.com5tag:blogger.com,1999:blog-5922058074088236083.post-85443350133136697712016-06-28T20:08:00.002+02:002016-06-28T23:54:16.182+02:00How we use Configmgr OSD Prestage to deploy 2500 laptops with almost no network loadThis post got a bit longer than intended ,jump to the bottom to read about how we use prestage task sequence to deploy 2500 laptops in a very short time period across 16 sites from one central Distribution Point with no network load and no interaction other than powering them on.
This may not be a good solution for everyone ,but it works very well for us.
We're happy since we can make Anonymoushttp://www.blogger.com/profile/18346125655776046808noreply@blogger.com0tag:blogger.com,1999:blog-5922058074088236083.post-12600810056668118882016-06-21T13:16:00.000+02:002016-06-27T10:42:05.363+02:00Distribution Point Dashboard Reports Latest version is 0.5(to update just rerun the script with the "-overwrite $true" parameter)
June 27 - have made some small adjustments to the reports.
The color rule for the package error was wrong ,it's now fixed.
Added Package type to the details report.
June 21 - Configmgr have skewed the dates by one day ,have corrected the dates in the query.
Had some trouble with content Anonymoushttp://www.blogger.com/profile/18346125655776046808noreply@blogger.com32tag:blogger.com,1999:blog-5922058074088236083.post-83656078160230237392016-06-15T09:32:00.001+02:002016-06-17T13:17:03.872+02:00Powershell Script - New Version of my SSRS Bulk Upload This Powershell script takes all report files(.rdl) in a folder ,creates the folder structure on the server ,uploads the reports and changes the data sources.
If you liked the first version of this script ,you'll love the new version.
The first version was written to solve a problem and nothing more, but turned out that it was something the SSRS community was waiting for as it is one of Anonymoushttp://www.blogger.com/profile/18346125655776046808noreply@blogger.com16tag:blogger.com,1999:blog-5922058074088236083.post-19706647206904446142016-06-07T09:25:00.000+02:002016-06-07T09:42:37.479+02:00SSRS Report Speed Problem. How to increase the speed of your SSRS Reports.
Backstory
I tried to show my colleague one of my new reports, but when he tried to open the report it wouldn't load. He could enter the parameters just fine, but the report itself just hung at the "Loading" screen.
Tried the same on my computer and the same thing happened. When i ran the report on the server itself either from the browser or from Report Builder everything worked fine.
My first Anonymoushttp://www.blogger.com/profile/18346125655776046808noreply@blogger.com0tag:blogger.com,1999:blog-5922058074088236083.post-60134408430483861232016-06-01T15:17:00.001+02:002016-06-07T11:48:55.905+02:00OSD Details ,Part 2 of my OSD Dashboard ReportAs promised, here is part 2 for my OS Deployment Dashboard.
It's designed to be a drill trough report from my OSD Dashboard,but you can also run it stand alone.
The query has been completely rewritten from my last report so it should be a lot more reliable than the last version.
Download Reports.zip
To upload the report ,download the zipfile and extract to a folder. you can upload Anonymoushttp://www.blogger.com/profile/18346125655776046808noreply@blogger.com18tag:blogger.com,1999:blog-5922058074088236083.post-72854767469687168592016-04-01T14:51:00.002+02:002016-06-07T12:06:13.210+02:00OS Deployment Dashboard
Update 7 June:
Have updated the download link with an updatec version(much faster) of the report.
If you downloaded the report before 7 June 2016 you should update to the newest version.
New version is also include the drill trough report (OS-OSD Details Report) so that you can click on a Computer to bring up the step by step details for that OS Deployment.
One of the first Anonymoushttp://www.blogger.com/profile/18346125655776046808noreply@blogger.com231tag:blogger.com,1999:blog-5922058074088236083.post-71959358576713374912016-03-23T11:17:00.000+01:002016-03-23T12:51:32.611+01:00How-to add Date filters to a reportThis is a quick post to answer a question i got in the comments of the "add collection selection" post.
The question was ,how to add start date and end date, start time and end time?
It's fairly easy to do ,all you need is a date field and the Between clause.
In this demo i'm going to use the client activity field as an example.
SELECT TOP 100 A.name0,
 Anonymoushttp://www.blogger.com/profile/18346125655776046808noreply@blogger.com0tag:blogger.com,1999:blog-5922058074088236083.post-79787489279254001052016-03-22T14:55:00.000+01:002016-03-22T18:52:08.099+01:00ConfigMgr Client Versions.(Updated to support up to 1602)Have updated this report to identify client up to 1602 ,you can either replace the whole report or just update the "clientinfo" query
Hi ,it's been a while since my last post so i thought i post a small report I created to check that my clients are running the latest version.
Don't know about you ,but i don't memorize version numbers ,so i created this report that maps the version numbers to Anonymoushttp://www.blogger.com/profile/18346125655776046808noreply@blogger.com12tag:blogger.com,1999:blog-5922058074088236083.post-38608846040018973402016-01-07T09:43:00.001+01:002018-07-09T14:23:31.544+02:00SSRS Search Filter
Hi
This is just a quick post to show how you can create a search filter to limit a long list ,in this case software info collected by Configmgr.
Combine this with multi valued parameters and you have a good method to show all software versions, even if the vendor don't keep the publisher name consistant.
In my case, if i didn't have the search filter the Publisher list would be 3338Anonymoushttp://www.blogger.com/profile/18346125655776046808noreply@blogger.com11tag:blogger.com,1999:blog-5922058074088236083.post-76850839290528526602015-04-27T09:35:00.001+02:002015-04-27T10:36:54.053+02:00How-to add a collection selection to almost any report.
This seems to be a common question so i desired to make a quick blog post a about it.
There are three parts to this ,first the part that you add to your query:
....AND ResourceID in (select ResourceID from dbo.v_FullCollectionMembership Where CollectionID = @CollectionID)
Notice: If your query have a where clause ,then you just tack it on with the AND operator. If your query does not have a Anonymoushttp://www.blogger.com/profile/18346125655776046808noreply@blogger.com5Tromsø, Norge69.649446368846327 18.945922851562569.47275036884632 18.3004758515625 69.826142368846334 19.5913698515625tag:blogger.com,1999:blog-5922058074088236083.post-68240747625377816052015-02-17T18:01:00.001+01:002015-02-17T18:02:48.595+01:00Followup post to The SSRS Bulk scriptJust a quick followup post to the Configmgr Bulk upload report script i posted a few days ago.
Got a question for a generic script to Bulk upload reports to SQL Reporting Services. With small modifications my script can be used.
I've just commented out the "change datasource" parts which is the only part thats specific for Configmgr ,the rest should work for any SSRS installation.
Download it Anonymoushttp://www.blogger.com/profile/18346125655776046808noreply@blogger.com0tag:blogger.com,1999:blog-5922058074088236083.post-10876799113056522342015-01-27T14:10:00.000+01:002016-06-15T09:34:50.590+02:00Powershell Script - Bulk import SSRS Reports and update datasourcesJune 15: New version of this script available ,get it here:new-version-of-my-ssrs-bulk-upload
For my first post of 2015 i give you a script that i wrote.
What this script does is it takes all .rdl files in a folder and imports them to your report server and changes the reports datasource to your Configmgr shared datasource.
This is useful if you need to import a lot of reports or if you're not Anonymoushttp://www.blogger.com/profile/18346125655776046808noreply@blogger.com5tag:blogger.com,1999:blog-5922058074088236083.post-41702023309914487112015-01-26T23:23:00.002+01:002015-02-13T13:47:47.240+01:00Silverlight missing from WSUS
As you might have noticed there's currently no update for Silverlight available for WSUS or Configmgr. Took me a while to figure it out ,so i thought I'd write a short post about it to save others some time.
You might have noticed that your clients is prompting you to update silverlight ,but when you check WSUS or SUP you can't find any silverlight updates.
The reason for this is that in the Anonymoushttp://www.blogger.com/profile/18346125655776046808noreply@blogger.com0tag:blogger.com,1999:blog-5922058074088236083.post-78787213821930340312014-11-27T23:54:00.000+01:002014-12-01T11:27:19.527+01:00MS Bulletin Quick Compliance Check
Ok ,it's been a while since my last post so i thought I'd share something useful and relevant.
Microsoft released a couple of out-of-band patches a few days ago that you should deploy asap.
To keep track of the deployment of patches belonging to a specific bulletin ID i created this quick and dirty report. Still some work left on this report ,but might still be useful
The report Anonymoushttp://www.blogger.com/profile/18346125655776046808noreply@blogger.com5tag:blogger.com,1999:blog-5922058074088236083.post-5607583214941821972014-10-21T12:50:00.000+02:002014-10-21T13:10:17.145+02:00Keep Track of your OS Deployments Part 2 (Drill-down Report) As promised ,here's the drill-down report for the OSD - Overview Report i posted last week. This OSD Details Report shows the run time and status of each step in a task sequence.
This report can either be run standalone or as a drilldown report for my OSD - Overview report that i posted last week.
This report is brand new so there might still be some kinks that needs to be sorted out.
Anonymoushttp://www.blogger.com/profile/18346125655776046808noreply@blogger.com0tag:blogger.com,1999:blog-5922058074088236083.post-42738451222158212542014-10-16T20:35:00.002+02:002016-04-14T14:00:21.640+02:00Keep track of your OS Deployments
Update: I've created a new and improved version of this report. you can find it here:
OSD Dashboard
Do you have full control over all OS Deployments in your organisation? Do you know how long each machine took to complete the task sequence? Do you know how many OS Deployments are running right now?
If other people is running your task sequences you probably heard stuff like "Task Sequences Anonymoushttp://www.blogger.com/profile/18346125655776046808noreply@blogger.com17tag:blogger.com,1999:blog-5922058074088236083.post-83669813509615002182014-10-16T10:33:00.002+02:002014-10-16T18:12:12.057+02:00Configmgr Report - Computers that don't have a specific software installed Thought i do a short writeup on how to use the mystical sub select query to find computers in a collection that don't have a specific software installed.
Software - Computers missing software.rdl
Download the RDL and change the "Datasource1" to suit your environment.
The report uses a simple search filter to limit the number of software titles in the "Select Software" Anonymoushttp://www.blogger.com/profile/18346125655776046808noreply@blogger.com4tag:blogger.com,1999:blog-5922058074088236083.post-91179655884400897502014-10-09T13:34:00.000+02:002014-10-09T13:56:46.324+02:00Dealing with version numbers in reportsIf you've tried creating a installed software report of some sort you've probably experienced that sorting by version number rarely work as you expect.
The problem is that SSRS looks at version numbers as decimals ,so Java 7 Update 9 (7.0.90) comes after Java Update 67 (7.0.670) when you sort them.
To fix this you need to split the version number ,convert them from strings to integers ,Anonymoushttp://www.blogger.com/profile/18346125655776046808noreply@blogger.com0