We are about to implement Symantec Enterprise Vault and we need to estimate our PSTsize 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
go to site hierarchy—>site settings—>client agents—software inventory client agent and add the file name intoinventory collection tab.
provide the sufficient information file name,location and if you search subdirectories as well.
Once this is done,make sure all the healthy SMS/SCCM clients passed software inventory client agent and sent its info to site server.
You can use the below report to identify how many/what computers not scanned software inventory client agent in 5 days.
select distinct a.netbios_name0,b.UserName0,c.LastScanDate as ‘Last software scan’ from v_R_System a
inner join v_GS_COMPUTER_SYSTEM b ON
a.ResourceID=b.ResourceID
inner join V_GS_Lastsoftwarescan c ON
c.ResourceID=a.ResourceID
where (DATEDIFF (dd,c.LastScanDate,GETDATE ()) > 5)
order by a.netbios_name0
now you have report on computers which are not sent their updated sinv information to site server.Good luck in troubleshooting .
you may refer inventoryagemt.log for troubleshooting.
Now you are ready to create SMS/SCCM report to list the file information,modified date ,path et information.
select distinct Sys.Name0,SF.FileName,SF.ModifiedDate as ‘LastModified Date’ ,SF.Filepath, SF.FileSize/1024 as Megs
from v_R_System Sys INNER JOIN v_GS_SoftwareFile SF on
Sys.ResourceID = SF.ResourceID
INNER JOIN v_FullCollectionMembership FCM on
FCM.ResourceID=sys.ResourceIDwhere SF.FileName like ‘%’+’.STF‘ and CollectionID=@COLLID and
SF.Filepath like ‘C:\documents and settings\%’
Order by SF.FileName
Where SFT can be changed to the required file it if is specified in software inventory client agent.
Prompt for COLLID:
select CollectionID,Name from v_Collection
