Report based on deployed script
Greetings,
I had to create a reg fix which I then deployed it via a script. I actually deployed it via Task Chains and targeted computers via labels.
I don't need a report on whether the reg fix did it change but more on which computers were missed (being offline, returned on inventory etc) so that we can target these at the end of the deployment.
I'm not good at SQL at all, but usually I'm okay with what the wizard has. I do have SQL reports that a co-worker created for pretty much most scenarios.
I have not seen any report built in or in the wizard that can tell me which computers individually or based on the labels received/completed (or whatever status) the deployment job.
Any ideas?
Thank you
Answers (1)
with the wizard the easiest way would be:
Create a Custom Inventory Rule with the Registy key contents.
With that you can have a label with systems with the old settings and can also report it via the report wizard
Comments:
-
Nico, I appreciate the response. The reason I don't necessarily care for the registry details is that our vulnerability scanner will detect if the PC is remediated.
I was hoping that I can figure out something like. Label called "Fix" has 50 computers assigned to it. From that Label, how many completed or are still in need of the deployment job. I don't need actual registry change as I've never really had an issue with KACE not deploying something correctly.
The reason for this is that I have to wait for computers to be scanned by the tool which can take up to 1 hour. My reporting method is for a quick status so that I can see why a computer missed the job. maybe it was offline etc.
Thank you - BarnOwl 1 year ago-
well, you don't have the results in the DB itself. You would need to go through the results which is complicated.
If you use the CIR you can easily (without much knowledge of SQL, which you meant you don't have) get this. Because you simply can query the CIR in the wizard _AND_ compare it against what you want. So this is, what you wanted to have.
Alternatively: you need to go deep into the DB with SQL knowledge 8/10 to get the info from the results if the script has been run and succeeded or not. But yes, you can do it, but since you said: you have not the experience to do so (and did not give ANY additional info) no one can give you a report for that. And with the CIR you can click it by yourself and for similar issues you can do it always. - Nico_K 1 year ago-
I've done CIR. Okay I see you point. I'll do it via CIR. Thank yo - BarnOwl 1 year ago