This tip will show you how to create a daily log of provisioned machines.
The existing Report for the K1000 Client Roll Out Log is fine for what it is: a list of all computers that have checked into the K1000 grouped by the date they were added.
During the initial rollout ( or provisioning) of an environment, it is nice to know that machines are being added each day or each week. TO create such a report, we need to duplicate the existing report and then modify it.
The nature of the modification is that we want to restrict the report to only machines that are new. You definition of 'new' may vary, and that can be taken into account.
Let's start!
- Navigate to Reporting -> Reports
- From the View Menu choose the Category "K1000"
- Click into the "K1000 Client Roll Out Log" to access the "K10000 Reports: Edit Report window
- Click the "Duplicate" button at the bottom of the report.
-- Canned Reports cannot be modified - Rename the Report "K1000 Client Rollout for Last 24 Hours" (or Last 7 Days if preferred)
-
Insert a couple of lines right before the last part of the existing report that reads:
order by CREATED_TIME -
Add the following text before "order by CREATED_TIME"
where CREATED > DATE_SUB(NOW(), INTERVAL 24 HOUR) - In the "Break on Columns field" delete the word "CREATED"
-
- Save the new Report. It should look something like this:
Now that the Report exists, it should be a simple matter of Scheduling it to be delivered to the appropriate email address(es) at the desired time.
Enjoy!
Comments