(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.
Had some trouble with content distribution to my distribution points last week. The patch Tuesday update package had failed to distribute to two of my DP's causing some clients to fail on installing patches.
The problem solved itself after some time,but it gave me an idea of a Distribution Point Dashboard, similar to my OSD Dashboard. The though is to have a single pane of glass to quickly give the information i need about my distribution points.
This is the result. as you can see I'm of the monochrome colour scheme for now, It's summer ,time for some more color!
Distribution Point Dashboard & Distribution Point Group Dashboard
Distribution Point Details
In the zip file you'll find a script to upload the reports and three reports in a sub folder. If you run the script with only the webservice parameter i'll upload the reports to ../Larsen Reports/Distribution Point/ folder and change the data source to your Configmgr Server
& '.\Upload Reports v3.ps1' -webServiceUrl http://yourreportserver.fqdn
(Read more about the script and additional parameters here)
(Read more about the script and additional parameters here)
About the reports
DP and DP Group Report are almost the same ,the only difference is the controls. If you only have a few distribution points or you don't use distribution point groups ,go ahead an use this one.If you have many distribution points the DP Group Report is a better choice, it allows you to first select a distribution point group and then select DP's from that group.
The Reports have a "Visual Limit" of about 10 DP's. The report will still work, but the graph might not be very readable with stats for 200 DP's on it:-)
The main part of the report is usage reporting for the DP's, but bellow that there a summary where i tried to show some useful info about the distribution points, like package status ,installed features and disk usage.
DP Details is as the name suggest for displaying details for a single distribution point. Displays a lot of the same information as the two others ,but it has details for all the packages on that DP. The Packages are sorted so that any problems are at the top.
It's linked up as a sub report for the two others ,but it can be run stand alone also.
Summary
Have had this report for two days and already it's paid of
- Found out that a few of our DP's where running low on disk space
- One of our very remote Distribution Points had 6 packages that where "failed" and one forever "in-progress"
- Our Endpoint Protection signature package was well overdue for a cleanup ,it contained 1732 files and was 2GB in size!!
If this report helped you spot and solve some problems/errors ,post bellow.
As always ,post questions and comments bellow and if you like this report feel free to spread the word on Twitter ,Facebook and so on:-)
Really nice report :)
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteFirst, Great reports! They will most definitly come in handy!
ReplyDeleteJust found a minor issue with the upload script, if you are using named instances in SSRS (as we do) the script will fail and you have to edit the script with the full path to your webservice. Once I did that everything worked nicely!
(I need to use Http://reportserver/Reportserver_INSTANCENAME/ReportService2010.asmx?WSDL)
Good tip.
DeleteI'll see if i can add some checks for this in later version of the script.
Looking good as usual! Thank you.
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteAwesome reports and good job, thank you!
ReplyDeletewhat a great report! Thank you it is very useful
ReplyDeleteAmazing! Excellent work! Works really well.
ReplyDeleteThanks Larsen
ReplyDeletesuperb Reports , please share if you have more custom reports for patching,sw deployment.
This comment has been removed by the author.
ReplyDeleteGreat reports, we have found them very useful!
ReplyDeleteI did have this idea for a report, although maybe it already exists and I'm just missing it.
Looking for a report that will list all packages across all DPs and indicate which DPs have which packages, something similar to this:
App/Package/Update Name DP1 DP2 DP3
Server 2008 Updates.............X......X
MS Office 2012.....................X...............X
Config Manager Package.....X.......X......X
Gah, that didn't come out right, essentially The X marks are supposed to be under the DP where the package/etc exists.
DeleteLike this?
DeleteCreated this kind of view for this report(s) ,but i didn't include it in the end.
http://imgur.com/a/Zt18V
Yes, that's exactly what I'm looking for!
DeleteHere: https://docs.google.com/uc?authuser=0&id=0B3gSJUbrB2yjYW5MOEdETk4zZ00&export=download
DeleteTry it out ,changed the colours to make it look like the others.
That's perfect, thanks!
DeleteHi Thomas when will you be releasing some more awesome reports
ReplyDeleteI run the report, I can get my dp names and groups to select so the datasource was changed correctly. But as far as unique clients and GB downloaded e.g. ... I only see "0". what am I missing?
ReplyDeletehmm ,check that your "v_DPUsageSummary" view has data (select top 200 * from v_DPUsageSummary)
DeleteThis comment has been removed by the author.
ReplyDeleteGreat ! Very useful !
ReplyDeleteBut I have a question. Some DPs "no data available" in the graph but they are in the table.
Do you know why ?
Excellent reports / dashboards ! Great job Thomas !
ReplyDeletethis is really amazing, don't know how to reward Thomas for such a great job
ReplyDeleteHi Buddy,
ReplyDeleteOutstanding reports, any idea why Package distribution status is not showing any data what so ever?
Any way to add in for DP Details the Schedule? Example we only allow distribution from 10pm to 5am. This is a pain to look at 50 some DPs to make sure that schedule is set.
ReplyDeleteGreat report! How can I change it to report a years worth of data or a specific date range?
ReplyDeleteWhen you need to purchase items, you will need to pay for this virtual currency in real-world currency as well. Want to know more about alternatif joker388? Find more information on this website.
ReplyDeletei am clicking on URL to download the Ps1, it's giving an error "We're sorry, but you do not have access to this page."
ReplyDeleteHow i can access this URL, please provide your suggestions.
This is a great report could you make it available again.
ReplyDeleteI see I'm not the only one looking for this report again. I changed jobs and didn't bring it with me. Please make it available again! I really don't want to have to try to make it myself...
ReplyDeleteCould you please make this report available again.
ReplyDelete