Getting Started with SQL Job SchedulesGetting Started with SQL Job Schedules

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

chris buck

Founder of SCCMF12TWICE.

Lead SCCM Architect/Engineer for various environment all over the world. Primarily focused on reducing complexity of enterprise environments. This also includes migrating customers to the cloud, and to windows 10 with servicing upgrades.

Strong believer in data driven operations. If we can identify problems with analytics, and visualize it to management we can reduce the amount of problems, at the same time improve customers experience, reducing support costs.

Add comment

11 + ten =

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Follow us

Don't be shy, get in touch. We love meeting interesting people and making new friends.

%d bloggers like this: