SQL


Comments

Post a Comment

Popular posts from this blog

Troubleshooting System Center Endpoint Protection (SCEP) Client

Image
Microsoft System Center Endpoint Protection provides an antimalware and security solution for the Microsoft platform. This can be integrated with System Center Configuration Manager. I have consolidated the information which are useful for SCEP client side troubleshooting. 1. Managing Endpoint Protection client with Command Line Interface – MpCmdRun.exe The MpCmdRun.exe (Microsoft Antimalware service command line utility) is very useful tool to manage local Endpoint protection client with command line.  The MpCmdRun.exe is located in C:\Program Files\Microsoft Security Client folder. On Windows 10 machines, the MpCmdRun.exe is available in C:\Program Files\Windows Defender folder. When executed, this command automatically creates a log file named as MpCmdRun.log in C:\Users\ username\AppData\Local\Temp folder. This log file records the commands that are executed using MpCmdRun.exe. Few of most commonly used command lines are listed below. For a complete l list of av...
Read more

SCCM Software Distribution Troubleshooting

Image
1.    Content Monitoring and Validation from Console The below article provide details of content monitoring and validation from console. https://blogs.technet.microsoft.com/inside_osd/2011/04/06/configuration-manager-2012-content-monitoring-and-validation/ 2.    Reports SCCM reports should be the first thing to check the software deployment status. By looking into the report you can determine the scope of failure such as large scale failure, location based failure or client specific issues. A large scale failure may be caused by an issue with package or programe while issue can be related with specific client if deployment failure rate is low and limited to few clients. There are multiple reports available for each category.  All Software Distribution reports can be found in below folders under Monitoring > Reporting > reports. ·          Software Distribution – Collections · ...
Read more

SCCM Deployment - Generating MIF file using VBScript

Image
The below VBScript will create the package installation status MIF file. The problem with the script initiated deployment is that it returns the success status even if the action performed by the script failed.   I have found this script on appdeploy website. The original script is located at http://www.appdeploy.com/messageboards/tm.asp?m=52414     Script Usage: SMSWriteStatusMIF “MIF File Name”, “Manufacturer”, “Product Name”, “Version”, “Description”,bSuccess   MIF File Name   : Name of the status MIF file. Manufacturer      : The application vendor Product Name     : Application name Version               : Application version Description         : The error description bSuccess             : True / False Script   Sub SMS...
Read more