Saturday, October 22, 2016

Collection 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 Inactive Clients), Endpoint Protection and Windows Update.

I decided to focus on these 3 tings in the first version of this report. There are probably hundred of other things i could have put in the report that would have been useful ,but can't have everything in one report.
Collection Summary Report

Note! The Collection Parameter dropdown list only shows Endpoint Enabled Collections. This is because Endpoint summary data is only collected for Endpoint Collections.
(Right Click the Collection --> Properties -->Alerts Tab --View this Collection in the Endpoint Protection Dashboard)

The report is divided in 3 sections ,Computers ,Endpoint Protection and Windows Update.

Computers:

The OS and Model chart should be pretty self explanatory ,but on the boxes on the right is meant to give some information on how many of the clients are inactive.

Endpoint Protection

The two graphs show Antivirus pattern age and Engine version. 
The list in the middle give a quick count of malware detected in the collection the last 14 days.
The boxes on the right shows summarized endpoint data ,how many endpoint clients in collection ,how many inactive clients and how many clients that are "at risk".

You can click the plus sign in the At Risk box to show a list of clients and whats wrong with them.


Windows Update

Windows Update shows you Compliant vs Non-Compliant pie chart and a Last scan graph. while the boxes on the right shows deployment and scan errors.

The Deployment and Scan Error Boxes can be clicked to bring up a details list ,giving some info on the problem. 
There's a tool-tip on the error codes that tries to resolve the error code.


The query for the Compliant vs Non-Compliant might not be what you expect it to be ,it's tuned to show what the site admins should worry about.
If you look at the where statement bellow I'll explain the reasoning behind this query.
  • We only look at the status "need update" ,if a client haven't evaluated an update yet and don't know if it needs it or not(unknown state) we just assume it'll be OK.
  • We only look at updates with severity of "low" or higher ,unclassified updates don't count:-)
  • We only look at deployed updates. If I haven't deployed the update they don't need to worry about it.
  • We don't care about expired and superseded updates!
  • We don't count update newer that 14 days ,giving the us a "graceperiod" where the clients can install the update before they're considered non-compliant. 
WHERE a.status = 2 AND b.severity >= 2
AND b.daterevised < dateadd(day,-14,getdate()) 
AND b.isDeployed = 1 AND b.isExpired = 0 AND b.isSuperseded = 0

This can  be tweaked to match your SLA.
If you don't have an SLA just ask yourself this ,how long after you've deployed an update before you expect that all clients have it installed. if the answer is 30 days ,set the grace-period to 30 days:-)


The Grace-period and minimum Severity is easily changed in the report. The if you need to change the other things you have to edit the query. 
If you don't like the Grace-period concept,just set it to zero:-)






42 comments:

  1. This report is not working for me. Get this error when trying to open it:
    The report server cannot process the report or shared dataset. The shared data source 'Configmgr' for the report server or SharePoint site is not valid. Browse to the server or site and select a shared data source. (rsInvalidDataSourceReference)

    ReplyDelete
  2. Unfortunately i have the same error :

    Le serveur de rapports ne peut pas traiter le rapport ou dataset partagé. La source de données partagée « Configmgr » définie pour le serveur de rapports ou le site SharePoint n'est pas valide. Accédez au serveur ou au site et sélectionnez une source de données partagée. (rsInvalidDataSourceReference)

    ReplyDelete
  3. You need to "verify" the collection created from the RDL once loaded and make the necessary changes for it to work in your environment. These is maybe helpful.

    https://www.systemcenterdudes.com/upload-rdl-file-to-report-server/

    ReplyDelete
  4. Thanks for your valuable information. It really gives me an insight on this topic. I'll visit here again for more information Visit: endpoint protection

    ReplyDelete
  5. New message after i reimport the rapport to my SCCM CMCB1610 :

    Une erreur s'est produite lors du traitement du rapport. (rsProcessingAborted)
    Impossible de lire la ligne de données suivante pour le dataset Windows_Update_Scan. (rsErrorReadingNextDataRow)
    Pour obtenir plus d'informations sur cette erreur, accédez au serveur de rapports sur le serveur local ou activez les erreurs distantes.

    For information, i car only use this collection : "All Desktop and Server Clients"

    ReplyDelete
  6. A little mistake about my next comment, i was for an other of report.

    The real message for this report :

    Une erreur s'est produite lors du traitement du rapport. (rsProcessingAborted)
    Impossible de lire la ligne de données suivante pour le dataset Windows_Update_Scan. (rsErrorReadingNextDataRow)
    La conversion d'un type de données varchar en type de données datetime a créé une valeur hors limites.

    ReplyDelete
  7. Although you embark within your quest towards hunt for the top commercial cleaning plumber here’s variety of points that you need to consider previously zeroing on one that fits a requirement not to mention bill much too. In Dubai, seek for a cleaning business enterprise that’s licensed by your National Habitat Agency (NEA). This would make sure higher values of vacuuming and experienced service by your company. home cleaning services

    ReplyDelete
  8. Great report! Is there any way to get all of the computer model information instead of just the ones with a higher quantity?

    ReplyDelete
  9. I installed this report on the reporting server. I have it working but the weird thing is that the graphs are not showing. It shows all the other info but not the pie chart. Any ideas?

    ReplyDelete
  10. Steps for making an essential report model in SQL Server Reporting Services. You can utilize the accompanying techniques to make a fundamental report model that clients in your site can use to assemble specific model-put together cleaning services in dubai reports based with respect to information in a solitary perspective on the Configuration Manager database.

    ReplyDelete
  11. We understand your problem and that is why we always deliver the assignment before the deadline.This is why it is a great idea to pay someone to do your assignment.
    pay to do assignments

    ReplyDelete
  12. For Programming Help, you need to take Programming Assignment Help and hire an expert for writing your projects.

    ReplyDelete
  13. A good news for you. GetAssignmentHelpOnline.com is providing you all subject assignment help in reliable price please visit
    Best Essay Writing Service

    Math Assignment Help

    Law Assignment Help

    Assignment writing service

    ReplyDelete

  14. If you are stuck with your Law assignment then in this case you can opt for our Law Assignment Help. we provide the bestLaw assignment writing UK.We also provideLaw Assignment and Essay Writing Help UK for students across the globe. for more information contact us +16692714848.

    ReplyDelete
  15. Looking for Online Assignment Help'? We can help you with your assignment writing tasks. Grades are the foundation to getting the job of their dreams as they enter the professional world and not getting good marks is costing thousands of students their dreams and ambitions. To prevent this from happening, the students are increasingly taking online homework help in Australia.

    ReplyDelete
  16. Glad to Visit Your Blog and read your blog post. Thanks!!
    Militar Hazardous Solutions is a leading and most preferred licensed contractor offering Asbestos Removal, Asbestos Surveying, Sampling & Disposal solutions.

    ReplyDelete
  17. Such a wonderful information blog post on this topic Allassignmentservices.com provides assignment service at affordable cost in a wide range of subject areas for all grade levels, we are already trusted by thousands of students who struggle to write their academic papers and also by those students who simply want ERP Assignment writing sevices to save their time and make life easy.

    ReplyDelete
  18. Understanding the concepts of hydroxyapatite, bioceramics, refractories, ceramic whitewares, superconductivity and advanced ceramics is tough. As a result, when students are given assignments on ceramic engineering they find it difficult to prepare. If you too are facing difficulty with your ceramic assignment, blindly choose Best Assignments Experts. We are a top-rated site that provides students with the best quality works as per their specifications. Our highly talented and professional Ceramic engineering help Australia experts have in-depth knowledge about every process and concept related to ceramic engineering. With their experience and dedication, they would craft a unique and original paperwork' which is sure to fetch you highest scores. Also, if you are working with us for the first time, you are entitled to discounts! So wait no more and contact us as soon as possible.

    ReplyDelete
  19. My name is Maya Bansal. I am 23 years old an adult entertainer with extreme stamina. I am always available to give you the best Agencys at affordable rates. I have big boobs, a charming face with a perfect body figure. I am a sexy Female Escorts in City. I will be the best companion for you and you will enjoy every single second with me. You will be fully fresh after and energetic after taking the best Agencys with Escort in City.
    Ludhiana Escort ##
    Hyderabad Escort ##
    Amritsar Escort ##
    Ranchi Escort ##
    Chandigarh Escort ##
    Patna Escort ##
    Jamshedpur Escort ##
    Agra Escort ##

    ReplyDelete
  20. We offer a large number of packages which is fit your budget. Now, customers can visit our site or call us on our Toll-free Number to know about flight information and cheap flight tickets with an instant booking facility on any Airlines Flights at the lowest and nominal airfare. Book now and save up to 40% OFF on every booking to anywhere around the world.

    delta airlines reservations
    spirit airlines reservations
    frontier airlines reservations
    air new zealand reservations
    delta airlines reservationsspirit airlines reservations
    frontier airlines reservations
    american airlines reservations

    ReplyDelete
  21. singapore Airlines Manage Booking. Get lowest fares on Domestic and
    International Singapore Airlines flight Booking with best discount & offers. Book your
    Singapore Airlines Manage Booking Number manage booking Number
    Singapore Airlines Manage Booking
    Singapore Airlines Phone Number

    ReplyDelete
  22. The materials provided by the Online dissertation help experts have grammar and spelling checked to remove any errors, formatted structure and the best writing style.

    Coursework Help USA

    ReplyDelete
  23. This comment has been removed by the author.

    ReplyDelete
  24. To read a clean suggestions and ideas, I searched for hours on this subject information and finally found your website releases. I read your post and I was very impressed and so glad after reading your posts. I hope you find out about your web page again. Thank you and Have a nice day dear admin. Good luck. Online Assignment Help - Best Assignment Help in Melbourne - online assignment provider in australia - assignments help

    ReplyDelete
  25. How amazing Your information is very detailed and useful to me, thank you for sharing. I hope you will always be up to date. We also provide affordable Your information is very detailed and useful to me, thank you for sharing from educational to travel and lifestyle. Dale is also associated with goto assignment help, where he helps students with assignments on request. who have gathered over the years providing their writing and editing assistance. Online Assignment Help If you are unsure of the results, please see our sample to deal with any Assignment Help

    ReplyDelete
  26. Global Assignment Expert provides one of the vital assignments like business assignments and marketing assignments with quality to the students. Among all the services, management assignment help is considered to be most demanded, since students find it delicate If you're one of those students, seeking the submission of stylish quality Assignments, you're just in safe hands. We, Global Assignment Expert, assure you to give assignments at an affordable rate with zero plagiarism. We have a highly secured gateway for smoother transactions.

    ReplyDelete
  27. I am just writing to make you understand what an outstanding experience I had going through your post, your article is a master piece, thanks much for sharing, you can also checkout this. calebuniversity cut off mark for computer science

    ReplyDelete
  28. Your information is very detailed and useful to me, thank you for sharing. I hope you will always be up to date. What Is Metabolism

    ReplyDelete
  29. Remarkable post. Thanks for sharing. If you need more help to write down amazing posts, get in touch with sourceessay.com associated homework help team now.

    ReplyDelete
  30. With start to end, experienced assignment writers will assist you with your university assignments. So, employ a virtual assistant and acquire exclusive documents in Australia, Malaysia, Singapore, the United Kingdom, and the United States. I have a Ph.D. in subject certification from top colleges, and our assignment writers have enough knowledge to manage assignments on a wide variety of subjects and topics. Visit now:- University Assignment Help

    ReplyDelete
  31. This is a very notable blog with a well-written article piece, very impressive as it contains information that is unique to its own. It is really worth surfing through, as it contains an amazing read. fcet omoku cut off mark

    ReplyDelete
  32. It's really nice thought; your article is giving me goose bumps. I've read these types of articles. These articles are such an inspiration one for me. Thank you for sharing. Visit 2nd batch admission list for uniport

    ReplyDelete
  33. Hi, your blog is truly faultless and unique. Wonderful contents, this is the best article i read with more information than any other blog zone. I liked it. Thank you so much for sharing this article with us. visit more info University assignment help

    ReplyDelete
  34. The Godrej Group is involved in a wide range of businesses, including real estate development, fast-moving consumer goods, advanced engineering, home appliances, furniture, security, and agri-care. We at Buddha Realtors bring you the best investment opportunity to invest in Godrej properties like Godrej palm retreat sector 150 Noida Godrej Woods, Godrej Nest, Godrej Nurture, Godrej Plumeria, Godrej Golf Link & .https://godrejpropertiescorp.com/godrej-palm-retreat/////url
    Godrej Palm Retreat Noida. Invest in these projects and get high returns on your investment.

    ReplyDelete
  35. Thank you for sharing this with everyone; you really know what you are writing! Once more thanks so for sharing! hse past questions pdf free download

    ReplyDelete

  36. Wow! This blog is great; I enjoy studying your articles. Keep it up! I know many people are looking for this information. You can help them a lot. Thanks for sharing. imsu-post-utme-de form

    ReplyDelete
  37. You really overwhelmed me with this information. After reading your educative content on your blog. I felt a sweet joy in my heart learning from your useful skillful review. Thanks so much for sharing. dennis osadebay university jupeb forms

    ReplyDelete
  38. Hi, your blog is truly faultless and unique. Wonderful contents, this is the best article i read with more information than any other blog zone. I liked it. Thank you so much for sharing this article with us. visit more info Top Study Tricks and Tricks for Pupils.

    ReplyDelete
  39. Services that help effectively with writing Assignment Help are welcome in Kuwait. Whenever you get stuck on a task, log on to the site to ensure they are creating quality courses that make difficult tasks easier by helping you solve them with minimal headaches. We are committed to a well-executed career with paperwork to enable you to perform well in a competitive environment for achievement. The task helps experienced experts at work. Fill it out in good time without documents. Students get A+ grades on projects and impress the professor. If the students have a job, they solve it at the same time. Therefore, students always prefer courses with homework support. Rush items are also available on this site.

    ReplyDelete
  40. Quick-drying and highly absorbent wholesale towels often used during sports or exercise activities.

    ReplyDelete