Silver and Gold Locks
Posted: Thu May 12, 2022 12:26 pm
Hello I have agents showing silver locks when they are encrypted and display keys. Other are gold as they should be. All system here are encrypted.
If Protection status = "On" then image = 1st image from list else image = 2nd from image list.
If you run the SQL query below, can you send us back the data? Select several agent ID's that show both on and off drives images and see what is returned here. Is it the image list being flakey or the data says its off when its really ON.
If you get Off data returned then lets test the bitlocker status on agent to see what command line says about current staus of encryption.
I really expect it to be a flakey list or just invalid data.
Where as computerID replaces {0} in SQL query below
Code: Select all
SELECT d. DriveID as ID,ConCat('',d.Letter,': - ',d.Model, ' Drive Size (',d.Size,'MB)') as Name, IF((v.ProtectionStatus = 'On'),'1','2') As Img FROM drives d LEFT JOIN plugin_p4a_bitlocker_volumes v ON d.ComputerID = v.ComputerID and d.letter = v.MountPoint WHERE d.FileSystem = 'NTFS' and d.ComputerID ='{0}' ORDER BY d.letter