Everything posted by Eswar Koneti
-
Make a query to find all unlicensed O365 installations?
here are the 2 blog post i have written to find the office365 activation details. http://eskonr.com/2019/09/check-microsoft-office-activation-status-using-sccm-compliance-settings/http://eskonr.com/2018/10/how-to-get-office-365-proplus-activation-status-and-excluded-apps-etc-using-sccm-configmgr/ Thanks, Eswar
-
Patch Management report statistics in SMS /SCCM
Have you looked at the default software update compliance reports? they do provide similar but more granular. Thanks, Eswar
-
SCCM Software Update issue
0x80072efe means "The connection with the server was terminated abnormally". Is this happening on all clients or specific machines ? can you try to restart windows update services and initate software update scan. you can start troubleshooting software updates using http://eskonr.com/2015/04/sccm-2012-troubleshoot-client-software-update-issues/ Regards, Eswar http://www.eskonr.com
-
Administration > Security > Accounts is empty
This tab shows the accounts that are configured in SCCM console ,it cab be like network access account, client push account etc. Unless you configure any accounts,this tab is empty. https://docs.microsoft.com/en-us/sccm/core/plan-design/security/configure-security#BKMK_ManageAccounts Regards, Eswar www.eskonr.com
-
Report that shows all devices user has logged onto.
Information that you are looking for (computer name and user name) is stored in V_R_system .so it is straight forward to get the information using SQL query (given below) select name0 from v_R_System where User_Name0 like 'eswar.koneti' If you need to customize it , use the SQL views https://gallery.technet.microsoft.com/SCCM-Configmgr-2012-R2-SQL-5fefdd3b and join the tables that you need info.
-
OneDrive Deployment
I havent tried this GPO method but if you have MFA enabled ,how does this work for users when they login to onedrive for the first time. we have ADFS on-prem (first factor )and MFA enabled (2nd factor). we did not configure any GPO options to associate so would like to know on this which users to avoid entering their email id/user name into the onedrive prompt.
-
OneDrive Deployment
i have deployed onedrive for business (17.3.7076.1026) to users without using script under detection method and it works fine for me .The below information help you http://eskonr.com/2017/12/how-to-deploy-onedrive-for-business-using-configmgr/ Install program:"OneDriveSetup.exe" /silent Detection method: Hive: HKCU Key:Software\Microsoft\Windows\CurrentVersion\Uninstall\OneDriveSetup.exe Value:Displayversion Type:String Operator:Equals Value:17.3.7076.1026 Install behaviour: Install for system Logon requirement: Only when user is logged on Program visibility : Normal rest of the settings are default unless you customize. If you are deploying older or newer versions ,make changes accordingly. Give a try this way.
-
Querying User Documentation Location
Properties of application and its deployment are stored in xml file in database. You need to review the xml and extract the information from it. Sample query is Avilable on my blog post http://eskonr.com/2015/05/sccm-configmgr-2012-how-to-extract-information-from-xml-file-stored-in-sql-db-for-application-properties/
-
Deploying Application by Location
You can also go work wmi query in task sequence to query the ip address or ou location or any other unique value that tell you the location of the computer.
- Secondary Site Installation Successful, but Not Working
-
Software Center Desktop Shortcut (Custom Icon)
you can try vbscript or relevant script something like this to place shortcut on users desktop http://eskonr.com/2013/04/sccm-vbscript-to-add-shortcut-files-to-users-desktop-profile-or-favorites/
-
Sccm 2012 - Assistance with software uninstall
Follow Niall method ,pick one client ,perform the uninstall using unattended ,put that in script/batch file ,create application/package/task sequence to remove application. SCCM follow what you feed to it
-
Software / Hardware scans not updating
this blog post might help to understand on this ,why clients hardware inventory date stamp was taking a long time to update in the Configuration Manager Console. http://www.esebenza.com/configuration-manager/client-activity-information-refresh-in-the-configuration-manager-console/,could be something similar ?
-
Linking to an existing WSUS setup with SCCM1606
Eswar Koneti replied to Johnny_Eyebrows's topic in System Center Configuration Manager (Current Branch)Go through the software update dependencies link here https://docs.microsoft.com/en-us/sccm/sum/plan-design/prerequisites-for-software-updates,it has all information before you link your existing wsus to CMCB. the most recommended and to avoid any future issues ,it is good to to with New WSUS server for your CMCB ,install SUP and get your clients patched.
-
wsus sync issue
it looks like you have issue with proxy .Check your proxy settings and try to sync again. also check wsusctrl.log and WCM.log if your settings are correctly configured or not.
-
Deploying Large Application "Cache Size is Full"
I would suggest to create configuration baseline to clean the ccmcache either fully or if size is less than x my, something like that and schedule to run the job weekly once or monthly once depends on the needs. Read the blog post for complete solution http://eskonr.com/2016/08/sccm-configmgr-how-to-clean-ccmcache-content-older-than-x-days-using-compliance-settings/ Regards Eswar Www.eskonr.com
-
Anyone have a script to find where a patch is DL'd to?
similar but can take input as title ,bulletin ID or article ID http://eskonr.com/2015/03/configmgr-2012-check-patch-is-member-of-what-software-update-package/
-
Lenovo Warranty Information
i would look at enhansoft for warranty information http://www.enhansoft.com/product/warranty-information-reporting for some custom solution.
-
SCCM 2012 R2 licensing
you can refer this guide http://www.techrepublic.com/blog/the-enterprise-cloud/making-sense-of-microsoft-system-center-licensing/ however,you need to contact your TAM (technical account manager) or the Microsoft guy to know about your existing license and going forward, how to manage the licenses .
-
Default REMINST share/NTFS permissions
what is the issue if everyone has read access ? they must need read permissions else boot will fail.
-
WMI Query to return Computer Objects with No Client installed
yes or you can create collection with below query: select SMS_R_System.ResourceId, SMS_R_System.ResourceType, SMS_R_System.Name, SMS_R_System.SMSUniqueIdentifier, SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.Client from SMS_R_System where SMS_R_System.Client = 0 or SMS_R_System.Client is null
-
Reboots in TS not working correctly?
is this happening across all machines or only specific ? have you added the patch to the task sequence in client installation step ? how did you set the sccm 2012 client installation task action ? something to look at http://henkhoogendoorn.blogspot.com/2011/01/task-sequence-fails-after-r3-client.html ?
-
Secondary vs DP for this layout
You can go with 1 Primary Site at A and rest can go with Distribution Points at other locations without looking at secondary site .
-
Removing Expired Updates from SUPs and DPs
Technet blog says 'we never delete any expired update associated with an active deployment, as we don’t want to remove anything associated with your deployments. It could be disconcerting if updates simply disappeared from your deployments and you had no idea why, so we just don’t do it.' it doesnt mean you should not delete the expired updates from active deployment. It depends how the organisations choose to do but i always delete the expired updates when ever i notice the updates expired to see all green color Deleting the expired updates also have impact on the packages (update to distribution points) so must look for schedule time when to remote the expired updates.
-
Check for a specific update
the best way to get this results is reporting. Create a SQL query to get computers missing the required patches instead of looking at collection. You have more flexibility with reports. Use the report http://eskonr.com/2015/10/sccm-configmgr-sql-query-how-to-get-list-of-patches-required-by-specific-computer/ ,modify to your needs.Patches are not like applications to check if specific patch installed or not as some patches may not be required by the client and it says Compliant (either Installed or Not applicable) so the best way is reporting to know the status (compliant,Non-Compliant and Unknown).
