Month: February 2007

Keyboard Data aka SMS asset management

SMS is a great tool for asset information, the key to SMS is under standing what information is available.   Some people might ask why I should care about keyboard information! The answer is that at some time management will ask a question like: How may “TBITS-5 Bilingual Keyboard” do we have?   It is […]

Hard Drive Stats

In yesterday blog I showed how you can sum the total hard drive space on each PC. Today blog goes along the same vain by  showing the minimum, maximum, average, and total of all hard drive within your SMS database.   SELECT             Min(v_GS_LOGICAL_DISK.Size0) AS ‘Min of HD Size’,             Max(v_GS_LOGICAL_DISK.Size0) AS ‘Max of HD […]

How much hard drive space and free space does each PC have?

  SELECT DISTINCT  v_GS_COMPUTER_SYSTEM.Name0 AS ‘PC Name’,  Sum(v_GS_LOGICAL_DISK.Size0) as ‘HD Space’, Sum(v_GS_LOGICAL_DISK.FreeSpace0) as ‘HD Free Space’, v_GS_COMPUTER_SYSTEM.UserName0 AS ‘Last Logon User’ FROM  v_GS_SYSTEM left join v_GS_LOGICAL_DISK on v_GS_SYSTEM.resourceid=v_GS_LOGICAL_DISK.resourceid LEFT OUTER JOIN v_GS_COMPUTER_SYSTEM ON v_GS_SYSTEM.resourceid = v_GS_COMPUTER_SYSTEM.ResourceIDGroup By v_GS_COMPUTER_SYSTEM.Name0,  v_GS_COMPUTER_SYSTEM.UserName0ORDER BY  v_GS_COMPUTER_SYSTEM.Name0

Discovery Query

This query will tell you, how many devices have been found by the various discovery methods in the pass 7 days.       select             AgentName as ‘Agent Name’,             count(AgentName) as ‘count’ from             v_AgentDiscoveries Where             Datediff(DD,agenttime,Getdate()) < 7 group by             AgentName order by             AgentName

Sum of HD space used by file type

The question below was posted within the Newsgroups. This is a typical question asked by Management, Servers or Exchange teams.   Managements reasons for know varies from “just because” to “Who is in violation of X Policy”   Server Team wants to know where they can clean up hard drive space. aka who is using […]

Bonus Post

This bonus post is mostly so that I can test Blog replication between this Blog and OWSUG.ca SMS blog. Up coming blog topics: Fun Links – Home Theater – Part 2 SQL Query – KB Descriptions What else would you like to see?      

Count of HF by Month

This query will give you a count of all hot fixes by Month. Keep in mind that a hot fix will have multiply version for example Windows 2000, Windows 2003, Windows XP, etc.   select             datepart (YY,daterevised0) as ‘Year’,             datepart (MM,daterevised0) as ‘Month’,             count(datepart (MM,daterevised0)) as ‘Count’ from             v_GS_PATCHSTATEEX Group by […]

How Microsoft can help user groups.

Last year I looked into becoming a MS partner for my company. After reading all the details that I could find I found out that it is very easy to become a registered partner with Microsoft. However it was another thing to become a certified partner or a gold partner. For those who don’t know, […]