Browse by Tags

listing all the views or tables of a database
Sunday, May 17, 2009 1:32 PM

Handy quick sql command guide from Marcus Oh on finding tables/views, again keeping here so I can find it if ever needed. http://marcusoh.blogspot.com/2009/05/listing-all-views-or-tables-of-database.html Read More...

by Rickym61 | with no comments

Filed under: sms, sql, sccm, ConfigMgr

sms query/report for spyware?
Monday, August 25, 2008 5:09 PM

This question seems to pop up on the list quite frequently, so to save time, here it is. It was originally posted to the list by Mark Mears, so credit goes to him, attached is the sql and sample of what results you may get again from Mark Mears SQL select all RSYS.Name0 AS 'Computer', RSYS.User_Name0 As 'Last User ID', SF.FileName As 'File... Read More...

by Rickym61 | 1 comment(s)

Filed under: sms, sql, spyware