cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Mister_Nobody
Honored Sweeper

LS has a powerful chart. It is Bar-diagram. It can show more than 2 column data.

I have developed SQL-query for AD Users. It have to be used with this type chart.

You should use report's name with prefix "Chart:".

Chart: Status of AD users
Query:

 

Select Top 1000000 tblADusers.Userdomain,
  Sum(Case
    When tblADusers.IsEnabled = 'false' Then 1
    Else 0
  End) Disabled,
  Sum(Case
    When tblADusers.IsEnabled = 'true' Then 1
    Else 0
  End) Enabled,
  Count(tblADusers.Username) All
From tblADusers
Group By tblADusers.Userdomain
Order By All Desc

 

At first, you have to enable checker to scan Disabled Users:

Mister_Nobody_0-1709198428073.png

After creation of the report you can add Chart Report on Tab via drag&drop it

Mister_Nobody_1-1709198531080.png

Choose Bar-type and show label. My result:

Mister_Nobody_2-1709198708991.png

1 REPLY 1
ErikT
Lansweeper Tech Support
Lansweeper Tech Support

Hi @Mister_Nobody 

Awesome job! Keep sharing these!

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now