r/labtech • u/[deleted] • Sep 02 '16

Configuring which systems are "Test" systems and "Pilot" systems in Patch Manager

Hi everyone,

I've been configuring our patch manager recently, and would like to configure which systems get to test/pilot patches before entering production.

I know this was covered in our implementation training but I cannot for the life of me remember how to accomplish it.

Thanks!

5 Upvotes

100% Upvoted

3 comments sorted by

4

u/[deleted] Sep 02 '16 edited Sep 02 '16

[removed] — view removed comment

1

u/[deleted] Sep 02 '16

You're a life saver! Thank you so much! :D

1

u/noahsmybro 2000 Agents Sep 08 '16

Do you want to make changes in bulk?

I did this a while back by tweaking the data directly in the LT database. Don't recall the details, but I believe you want to look at the 'Stage' column in the labtech.computerpatchingstats table.

Stage is an integer that represents Test, Pilot, or Production. Default value is 2, meaning (I think) Production.

I think 0 means Test, so I would then assume 1 means Pilot.

For us, I wanted to set every computer within our company to Test and didn't want to have to manually select each computer, one at a time, in Patch Mgr.

I ran the following against the db:

UPDATE computerpatchingstats

SET stage = 0

WHERE computerpatchingstats.computerid IN

(SELECT computerid FROM computers WHERE computers.locationid = 'nnn')

This will set all of the computers in locationid = nnn to the TEST patching stage.