Jump to content
MrBond68

Showing active Power Profile

Recommended Posts

Hi, I need to see active Power Profiles for every agent.

Would work with a DataView but cant find the field.

Cant find it with advanced serach either.

Anyone know how to get this information in a table format or some other way?

 

2019-11-21_162225.png

Share this post


Link to post
Share on other sites

If you can do a SQL search try this. 

I based this on from this post written by @DarrenWhite99

SELECT DISTINCT SUBSTRING_INDEX(SUBSTRING(PowerProfiles,1+LOCATE(',',PowerProfiles,
LOCATE(CurrentPwrProfile,PowerProfiles))),'|',1) AS CurrentProfileName, 
computers.CurrentPwrProfile AS Identity, 
computers.ComputerID, 
computers.Name AS `ComputerName` 
FROM computers 

 

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...