Asset Explorer Queries Needed

Asset Explorer Queries Needed

MS SQL Server being used.

I need a query that will return an integer. I need all of the workstations that are not like %ThinkCentre% and assigned to these 4 departments.

'Inventory 1'
'Inventory 2'
'Inventory 3'
'Inventory 4'

I just need it to return a count. No header, no extras, just an integer. Please help!

                  New to ADSelfService Plus?