About S_B

S_B · 02-28-2019

I have 2 Reports with assets.Some assets are in both assets, but I would like to have only thoese assets who are either missing in the first or the second report.How can I compare 2 reports with each other ?Thanks for answers.BR Sascha

S_B · 02-12-2019

I really really need your help please.I have looked into every similar thread here in the forum, but non of those solutions work for me I am looking for an very simple report, unfortunately I do not have the knowledge for it.I need a report which re...

S_B · 11-16-2018

I am looking for a report which shows me all Windows 7 & 10 Clients (no Servers, no Linux) that do NOT have approved software installed.Maybe someone can help me as my SQL knowledge is very basic.Many thanks.Edit:Also I would like to know which appro...

S_B · 02-15-2019

Thank you, this worked fine. And how do I get it work that only domain devices are shown ?I tried with this:And tblAssets.Domain Not Like 'WORKGROUP'But this does not work at all. Even if I pick this under Select Top 1000000Many thanks.

S_B · 02-15-2019

This is my code so far:Select Top 1000000 tblAssets.AssetID, tblAssets.AssetNameFrom tblUsers Join tblAssets On tblAssets.AssetID = tblUsers.AssetIDWhere tblUsers.Name <> 'GC'Group By tblAssets.AssetID, tblAssets.AssetNameI just dont know how I ca...

S_B · 11-07-2018

How can I get the showing SWITCH to be clickable ?

Re: Local Admin Group Members · 10-30-2018

Thanks a lot, works perfect.

User Statistics

User Activity

Compare 2 Reports

Specific local user not in local admin group => Result Device name

Approved Software not installed Win7 & 10

Re: Specific local user not in local admin group => Result Device name

Re: Specific local user not in local admin group => Result Device name

Re: Assets and the switch they're connected to

Re: Local Admin Group Members