→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
itdpt
Engaged Sweeper
Hello

I need to have a report where i get a list of all computer with status active .

I've tried with this =

Select tblCompCustom.Computername, tblCompCustom.State
From tblCompCustom Inner Join
tblComputers On tblComputers.Computername = tblCompCustom.Computername
Where tblCompCustom.State = 2

but it did not give me any kind of result.


thank You

Ict dpt
2 REPLIES 2
itdpt
Engaged Sweeper
thank You

got it working !

Cheers
Hemoco
Lansweeper Alumni
try this:

Select tblCompCustom.Computername, tblCompCustom.State
From tblCompCustom Right Join
tblComputers On tblComputers.Computername = tblCompCustom.Computername
Where tblCompCustom.State = 1