Error in PXE Role uninstallation

Error : Unable to delete PXE Role in sccm,

Solution :
Run following sql query in sccm Database.


delete from pkgservers where NALPATH like '%\\sccm server name\smspxeimages$%'
delete from pkgstatus where pkgserver like '%\\sccm server name\smspxeimages$%'

After this, we can able to delete PXE role.

SCCM Report to collect video file information

collecting video file information using SCCM Report

1) add video file extension in inventory collection under software Inventory client agents properties as shown below.

once added all required extension in inventory collection, run software inventory client agent on all systems.

2) Create SCCM Report now, ( i used SQL Server Business intelligence studio configured already)

 In solution explorer, right click -> Reports -> Add new report

 Next

Next

Copy SQL Query into : query string and click on Query Builder ( sql query available below )

SQL Query : 

SELECT     SYS.Netbios_Name0 AS 'System Name', SYS.User_Name0 AS 'User Name', SF.FileName, SF.FilePath, SF.FileSize AS 'FileSize(Byte)', SF.FileModifiedDate,

FCM.CollectionID

FROM         v_GS_SoftwareFile AS SF INNER JOIN

v_R_System AS SYS ON SF.ResourceID = SYS.ResourceID INNER JOIN

v_FullCollectionMembership AS FCM ON FCM.ResourceID = SYS.ResourceID

WHERE     (SF.FileName LIKE '%.avi%'

or sf.filename like '%.3gp'

or sf.filename like '%.flv'

or sf.filename like '%.mov'

or sf.filename like '%.mp4'

or sf.filename like '%.mpg'

or sf.filename like '%.mpeg'

or sf.filename like '%.wmv'

or sf.filename like '%.divx'

or sf.filename like '%.mkv') AND (FCM.CollectionID = @CollectionID)

ORDER BY 'FileSize(Byte)'

Select check box : CollectionID and enter OK

Select CollectionID check box 

Enter the name of the Report

OUTPUT : 

Any help required : prakaash2109@gmail.com

Uninstall uTorrent Completely using command line

How to uninstall uTorrent Completely from system.

1) open notepad and type following command.


cd "C:\Program Files\uTorrent"
uTorrent.exe /uninstall /s
rmdir /s /q "C:\Program Files\uTorrent"
reg delete HKEY_CURRENT_USER\software\BitTorrent /f
reg delete HKEY_CURRENT_USER\software\BitTorrent\uTorrent /f
reg delete HKEY_CLASSES_ROOT\.torrent /f
reg delete HKEY_CLASSES_ROOT\Applications\uTorrent.exe /f
reg delete HKEY_CLASSES_ROOT\uTorrent /f
reg delete HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Run /v uTorrent /f

save as batch file ( .bat ) and run. it removes uTorrent completely from your system.

same batch file we can create package through SCCM and distribute via software distribution.