SQL Query to Show Any missing Boundaries in the SCCM Hierarchy

by

SELECT DISTINCT v_R_System.Name0, v_R_System.Client0, v_RA_System_IPAddresses.IP_Addresses0, v_RA_System_IPSubnets.IP_Subnets0, v_RA_System_SMSAssignedSites.SMS_Assigned_Sites0 FROM v_R_System LEFT OUTER JOIN v_RA_System_IPSubnets ON v_R_System.ResourceID = v_RA_System_IPSubnets.ResourceID LEFT OUTER JOIN v_RA_System_IPAddresses ON v_R_System.ResourceID = v_RA_System_IPAddresses.ResourceID LEFT OUTER JOIN v_RA_System_SMSAssignedSites ON v_R_System.ResourceID = v_RA_System_SMSAssignedSites.ResourceID WHERE (v_RA_System_SMSAssignedSites.SMS_Assigned_Sites0 IS NULL) AND (NOT (v_RA_System_IPAddresses.IP_Addresses0 IS NULL)) AND (v_R_System.Client0 IS NULL) AND (NOT (v_RA_System_IPSubnets.IP_Subnets0 IS NULL)) order by v_RA_System_IPSubnets.IP_Subnets0

Confuse – USMT & MDT & SIM

by

The confusing parts … 1) USMT: Will have below files MigApp:- To migrate the Application settings like Outlook dictionary Miguser:- To migrate the Local Users membership MigDoc:- TO migrate the File types that you wanted to migrate Custom.XML: the above three can be overwriten if you want any of above or apart from that to … Read more

SCCM + MDT Driver Management – Good Info To Read

by

Below are the options that i could see to automate the Drivers for different models…For DELLhttps://en.community.dell.com/techcenter/systems-management/w/wiki/repository-manager.aspx Dell Repository Manager is an application that allows IT Admins more easily manage system updates. Repository Manager provides an easy to use, searchable interface used to create custom collections known as bundles and repositories of Dell Update Packages (DUPs).  A Dell Update Package … Read more

Where to start the Forefront Endpoint Protection

by

Here is starting point to work with SCCM+Forefront Download the Trial Softwareor use the Virtual Labs “ Forefront Endpoint Protection TechNet Virtual Lab: Forefront Endpoint Protection: Deploy FEP 2010 Clients TechNet Virtual Lab: Forefront Endpoint Protection: Monitoring, Alerting and Reporting Part 1 TechNet Virtual Lab: Forefront Endpoint Protection: Monitoring, Alerting and Reporting Part 2 TechNet … Read more

License 15A – General License Reconciliation Report by Machine

by

Most of the time people will get tried to import the third party license file however due to some Characters limitation or some other we will get errors while importing the .csv file. The easy solution i can see it a free utility called CT-AILW.exe.read here more ….https://blog.coretech.dk/kea/asset-intelligence-3rd-party-software-utility/ Configuring the utility Once you have downloaded … Read more

How can I install BDP without any issues?

by

How can I install BDP without any issues? Steps to enable Successful BDP: 1. Login to the Target system and uninstall the existing SCCM Client 2. Create a Test collection and add the Target system to the collection. 3. Use delete special to delete the Computer Record. 4. Login to the target BDP Computer 5. … Read more