SQL Query BIOS PASSWORD ON SYSTEMS (Dell and HP)

, , , , ,

Prior to deploying the proprietary client tools described in the sections below, it is helpful to first identify which systems have administrator and/or system passwords configured because some of the tools’ functionality will fail if these passwords are set and not used during deployment.In order to use certain proprietary management tools to make changes to the BIOS/UEFI settings, it is necessary to determine which systems are currently configured to require passwords before settings can be modified. The queries will identify systems that need a password.

Dell

Select
sys.Name0,
DBP.AttributeName0,
ElementName0,
DBP.IsSet0
from
v_GS_DCIM_BIOSPASSWORD0 DBP
Inner Join
V_R_System sys on sys.ResourceID = DBP.ResourceID
Where DBP.IsSet0 = ‘1’
Order By sys.Name0, DBP.AttributeName0

HP

Select
sys.Name0,
HPBP.Name0,
HPBP.IsSet0
from
v_GS_HPBIOS_BIOSPASSWORD HPBP
Inner Join
V_R_System sys on sys.ResourceID = HPBP.ResourceID
Where HPBP.IsSet0 = ‘1’
Order By sys.Name0, HPBP.Name0

 

ALSO SEE : Secondary Site stuck in “Deleting” state