Track movies, mp3 and photos from SCCM 2007

Agenda
Track movies, mp3 and photos from SCCM 2007

solution :-

To acheive this, we need to enable inventory all requested format in SCCM 2007.

123

 

After enabling the above settings, use the below query to get the details.

select

distinct

sys.Netbios_Name0 ‘Computer Name’,

sys.User_Domain0 ‘Last Logged on Domain’,

sys.User_Name0 ‘Last Logged on User’,

soft.FileName‘File Name’,

soft.FileDescription ‘File description’,

soft.FileVersion ‘File version’,

soft.FilePath ‘File Path’

from

v_GS_SoftwareFile soft

join v_R_System sysonsys.ResourceID = soft.ResourceID

join CollectionMembers coll on Coll.MachineID = soft.ResourceID

join Collections cols on cols.SiteID = Coll.SiteID

where soft.FileName like ‘%.AVI’

Or soft.FileName like ‘%.MPEG’

Or soft.FileName like ‘%.asf’

Or soft.FileName like ‘%.WMV’

Or soft.FileName like ‘%.MPEG1’

Or soft.FileName like ‘%.MPG’

Or soft.FileName like ‘%.M1V’

Or soft.FileName like ‘%.MP2’

Or soft.FileName like ‘%.WAV’

Or soft.FileName like ‘%.SND’

Or soft.FileName like ‘%.AU’

Or soft.FileName like ‘%.AIF’

Or soft.FileName like ‘%.AIFC’

Or soft.FileName like ‘%.AIFF’

Or soft.FileName like ‘%.ASF’

Or soft.FileName like ‘%.WM’

Or soft.FileName like ‘%.WMA’

Or soft.FileName like ‘%.WMV’

Or soft.FileName like ‘%.BMP’

Or soft.FileName like ‘%.JPG’

Or soft.FileName like ‘%.JPEG’

Or soft.FileName like ‘%.JPE’

Or soft.FileName like ‘%.JFIF’

Or soft.FileName like ‘%.GIF’  

Or soft.FileName like ‘%.MP3’

Or soft.FileName like ‘%.AIF’

and cols.CollectionName in(‘all systems’)

group by cols.CollectionName, sys.Netbios_Name0, sys.User_Domain0, sys.User_Name0, soft.FileName, soft.FileDescription, soft.FileVersion, soft .FilePath

Advertisements
This entry was posted in SMS Query and tagged , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s