One of the typical features of Configuration Manager is the installation of operating systems, often abbreviated as OSD (Operating Systems Deployment). This functionality is implemented with the help of Task Sequences, using the so-called Boot Image, which allows to identify in the used Task Sequence resources just such a resource (denoted by the number 257, as a type of package).
Monitoring the operation of OSD we usually focus on statistics on a single process (a single sequence). Meanwhile, for the evaluation of the intensity of the station installation process, it is more convenient for us to consider various sequences together and determine their final outcome: success or failure. Such information can be obtained from an SQL database using a query that, with a slight modification, can not only determine the number of installations started per hour, but also completed successfully or with an error.
SQL query specifying the number of OSDs started per hour:
In case we care about getting the rate of successful installations per hour, we can use a query:
Finally, unsuccessfully completed trials OSD per hour:
Of course, from SQL or even SQL reporting services we will get instantaneous values, which for comparisons or further analysis is not enough. You can take advantage of these queries by constructing rules that collect performance (Performance Collection Rules) within Operations Manager and thus obtain comparative data. This makes it possible later to indicate typical installation habits (for example, favorite time of day), when the number of installations undertaken is the highest, and even to indicate the "unlucky day of the month for installations" and I don't suppose it's the famous Friday the 13th 😉 .