Archive

Posts Tagged ‘SCCM Reports’

Track Local Network Shares on SCCM 2007

Hi,

If you need to find all the local shares that users create on their computer this post might be good for you,

The first thing you need to do is to edit the sms_def.mof file for the client to start reporting of his local shares\

  1. Open the file …\Microsoft Configuration Manager\Inboxes\clifiles.src\hinv\sms_def.mof with your notepad
  2. search for   SMS_Group_Name (“Shares”), 
  3. You can change all the FALSE parameters to TRUE, or just the SMS_Report, Name and Path
  4. Now you need to wait, it can take some time that the client will start reporting about his shares

The second thing to do is to build a small report, you can use a basic report that show all the shares

SELECT TOP (100) PERCENT dbo.v_GS_SHARE.ResourceID, dbo.v_R_System.Name0 AS Hostname, dbo.v_GS_SHARE.Name0 AS ShareName,
dbo.v_GS_SHARE.Path0 AS Path
FROM dbo.v_GS_SHARE INNER JOIN
dbo.v_R_System ON dbo.v_GS_SHARE.ResourceID = dbo.v_R_System.ResourceID

Or you can use some filter to disable administrative shares

SELECT TOP (100) PERCENT dbo.v_GS_SHARE.ResourceID, dbo.v_R_System.Name0 AS Hostname, dbo.v_GS_SHARE.Name0 AS ShareName,
dbo.v_GS_SHARE.Path0 AS Path
FROM dbo.v_GS_SHARE INNER JOIN
dbo.v_R_System ON dbo.v_GS_SHARE.ResourceID = dbo.v_R_System.ResourceID
WHERE (dbo.v_GS_SHARE.Name0 NOT LIKE ‘_$’) AND (dbo.v_GS_SHARE.Name0 <> ‘admin$’) AND (dbo.v_GS_SHARE.Name0 <> ‘ipc$’)

I’m done here , on my next post I’ll show how to generate report of permission of those shares.

Advertisements

PST Inventory With SCCM

09/01/2011 4 comments

Hi,

We are about to implement Symantec Enterprise Vault and we need to estimate our PST size on our laptops,

So I set the Inventory Collection (Site management ->Site name -> Site settings -> Client agents (properties) -> software inventory client agent)

It will take a few days until the DB will be entered with the information we need, (I set up the software inventory schedule to run every 1 day for the first week, after i have all the information i’ll set it back to run every 7 days as the default setting)

Now There is few ways to see the PST data:

1. Use built-in report called Computers with a specific file and in the file name use %.PST

You should see something like:

2. Use Custom Report For PST as I found on System Center Forum by John Marcum

PST’s on a Client

select Sys.Name0, Sys.User_Name0, SF.FileName, SF.FilePath, SF.FileSize/1024 as Megs
from v_R_System Sys INNER JOIN v_GS_SoftwareFile SF on
Sys.ResourceID = SF.ResourceID
where SF.FileName like ‘%’+’.PST’ and Sys.Name0= @System
Order by SF.FileName

PST’s on Client Count

select Sys.Name0, Sys.User_Name0,
Count(SF.FileName) as FileCount,
Sum(SF.FileSize/1024/1024) as ‘Megs Used’
from v_R_System Sys INNER JOIN v_GS_SoftwareFile SF on
Sys.ResourceID = SF.ResourceID
where SF.FileName like ‘%’+’.PST’ and SF.FileSize/1024/1024 > 0
Group by Sys.Name0, Sys.User_Name0
having Count(SF.FileName) > 1 order by Sys.Name0 Desc

That’s It,

yair

Resources Installed Date Report On SCCM 2007

Hey All, This is My First post on this blog, My colleagues From Diplomat will Join us Soon.

And now for the issue presented, Say you want to list all your all OS’s by installed date, sccm offer you this for every version and not for all your operating systmes, So if you want your  report to look like this one:

All You need to do is creat new report and add This SQL statement:

SELECT     DISTINCT dbo.v_R_System.ResourceID, dbo.v_R_System.Name0, dbo.v_GS_OPERATING_SYSTEM.InstallDate0,
dbo.v_GS_OPERATING_SYSTEM.LastBootUpTime0, dbo.v_GS_OPERATING_SYSTEM.Caption0, dbo.v_GS_OPERATING_SYSTEM.Version0,
dbo.v_GS_OPERATING_SYSTEM.CSDVersion0
FROM         dbo.v_R_System INNER JOIN
dbo.v_RA_System_IPAddresses ON dbo.v_R_System.ResourceID = dbo.v_RA_System_IPAddresses.ResourceID INNER JOIN
dbo.v_GS_OPERATING_SYSTEM ON dbo.v_R_System.ResourceID = dbo.v_GS_OPERATING_SYSTEM.ResourceID
WHERE     (dbo.v_R_System.Client0 = 1)

Thats It, Have Fun

Yair

Categories: Microsoft, SCCM Tags: ,