Monday, September 13, 2010

Find Machines with NULL Software Inventory

SELECT DISTINCT
a.Name0,
a.resourceid,
a.Creation_date0,
a.Obsolete0,
a.Client0,
a.Active0,
b.LastScandate AS LastSWscan,
c.LastHWscan
FROM v_r_system AS a
LEFT OUTER JOIN v_GS_LastSoftwareScan AS b
ON a.resourceid = b.resourceid
LEFT OUTER JOIN v_GS_WORKSTATION_STATUS AS c
ON a.resourceid = c.resourceid
WHERE a.Name0 IN (SELECT Name0
FROM v_r_system
GROUP BY Name0
HAVING COUNT(*) < 2)
AND (b.LastScandate is NULL and a.Client0 =1 and a.Obsolete0=0)
ORDER BY c.LastHWscan, b.LastScandate desc

4 Comments:

Anonymous Inventory Management Software said...

I really appreciate your post and it was superb .Thanks for sharing information.

December 28, 2010 at 10:40 PM  
Anonymous Inventory POS System said...

I like your article and it really gives an outstanding idea that is very helpful for all the people on web.

January 20, 2011 at 2:13 AM  
Anonymous Inventory POS System said...

I like your article and it really gives an outstanding idea that is very helpful for all the people on web.

January 20, 2011 at 2:19 AM  
Anonymous Best SMS Software said...

Thank you Jaison,
This is a great write and useful for the reader.
Thanks again for sharing.

February 27, 2011 at 1:02 PM  

Post a Comment

Subscribe to Post Comments [Atom]

Links to this post:

Create a Link

<< Home