SCCM

688

Solutions

642

Contributors

Systems Center Configuration Manager (SCCM, formerly known as Systems Management Server) is Microsoft’s system software for managing large groups of not only Microsoft computers, but those running other operating systems, such as Linux, OS-X, and various mobile technologies.

Share tech news, updates, or what's on your mind.

Sign up to Post

SCCM  Windows 7 to 10 upgrade fails only on PCs with specific app used by one department.  I Can manually upgrade Windows 10 on the same PCs.

Is there a way to exclude the one app from Windows10 upgrade from falling back to 7?
0
Take Control of Web Hosting For Your Clients
LVL 12
Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

Dear expert

Below script code works fine i powershell, Im trying to add this in the orchestrator(A SCCM add-in) I got this error:

Cannot bind parameter 'Date' to the target. Exception setting "Date": "Object reference not set to an instance of an object."
Seems it complain this: $dateFilter = get-date $dateFilter -format yyyy-MM-dd, I kinda knew that SSCM Orchestrator use the old PS version, now I dont know what to do to fix this problem. Well the function Im after is: when you run the script till well first get running date with format yyyy-MM-dd and then use that line into a sql query.

Anyone know the solution for it? Thanks.

$SQLServer = "System"
$SQLDBName = "Prod"
$months = 2
$dateFilter = get-date $dateFilter -format yyyy-MM-dd

function f_sqlquery ($dateFilter) {

      $SqlQuery = "
      DECLARE
            @ReminderMonth date = '$dateFilter';
      DECLARE
            @P1 int = (      SELECT      COUNT(*)
                              FROM        Invoice.Reminder R
                              WHERE       R.DatetimeSentToReceiver >= @ReminderMonth
                              AND R.DatetimeSentToReceiver < DATEADD(MONTH, 1, @ReminderMonth)
                              AND R.ReminderNumber = 1 ),
            @P2 int = (      SELECT      COUNT(*)
                              FROM        Invoice.Reminder R
                              WHERE       R.DatetimeSentToReceiver >= @ReminderMonth
                              AND R.DatetimeSentToReceiver < DATEADD(MONTH, 1, @ReminderMonth)
                              AND R.ReminderNumber = 2 ),
            @P3 int = (      SELECT      COUNT(*)
                              FROM        Invoice.Reminder R
                              WHERE       R.DatetimeSentToReceiver >= @ReminderMonth
                              …
0
Today, we are faced to very strange problem. I tried to create computer association (user state migration) with 2 computers. We got an error message "Configuration manager cannot back up all the user accounts for this association because the source computer is associated with another computer that is not configured to back all user accounts ..."
I verified user state migration, there is nothing associated with the source or destination PC. The same result after verification of SQL DB, view v_StateMigration. There are no records.
Do you have any idea? Thank you
We are using SCCM CB 1710 + Hotfix rollup KB4057517
0
I try to update System Center Configuration Manager to version 1706.
The status is "Applicable", but if you right click only have the option for "Show Status" other options are grayed out.
If you click Show Status, Download is in progress.
I already try:

1.delete the package under EasySetupPayload folder

2.delete SQL record by this command:
DELETE FROM dbo.CM_UpdatePackages WHERE PackageGuid = '0f11caa4-7f7f-454b-96d6-75f427d015ce'

3.Use CMUpdateReset.exe reset the package:
CMUpdateReset.exe -FDELETE -S sccm2012.mydomain.com -D CM_MYD -P 0f11caa4-7f7f-454b-96d6-75f427d015ce

After that the package was deleted on the Console, but when it try to download again, it stuck in the same spot.
Pack-Status.PNG
Right-Click-configuration-Manager-17.PNG
dmpdownloader.log
0
Hi,

I'd like to see how many devices have which version (build number) of Office 2016.
Have the query but not the group by, please advise howto.

SELECT DISTINCT  
  SYS.Name0
  ,ARP.DisplayName0 As 'Software Name'
  ,ARP.Version0 As 'Version'
  ,ARP.InstallDate0 As 'Installed Date'
 FROM
  dbo.v_R_System As SYS
  INNER JOIN dbo.v_FullCollectionMembership FCM On FCM.ResourceID = SYS.ResourceID
  INNER JOIN dbo.v_Add_REMOVE_PROGRAMS As ARP On SYS.ResourceID = ARP.ResourceID
 WHERE  
 (ARP.DisplayName0 LIKE '%Microsoft % Standard%'
 OR ARP.DisplayName0 LIKE 'Microsoft % Professional%'
 OR ARP.DisplayName0 LIKE 'Microsoft % Enterprise %')
 ORDER BY Name0 ASC
0
Hi All,

I am currently in the process of creating a new sccm server (current branch). This is to replace our old SCCM 2007 environment.

The reason i am not doing a side by side upgrade is due to our plan to upgrade all pc's to windows 10.

Our 2007 SCCM is live for our w7 pc's. I do not require any of the information to be migrated e.g. packages, OS images etc. i would like to set up a new sccm current branch environment and set this up with windows 10 images and packages and test deployment building just windows 10 computers / packages.

I am aware that both site codes need to be unique, i am just a little confused when it comes to boundaries. Our 2007 environment boundaries are set by IP subnet. When i configure the new SCCM current branch will i have problems if i set the same IP subnet boundaries?

The end goal is to have W10 clients going to the new SCCM current branch and then phase out the 2007 SCCM as pc's are replaced with W10. Once all W7 clients are upgraded i can decommission the 2007 SCCM.

Apologies if any of the above does not make sense i am rather new to SCCM.

Many Thanks
0
Can you please help me to create an SCCM2016 Architecture diagram for 7000 servers/clients distributed across two datacenters?
0
I'm beginning the installation of system Center 2016 in my environment

Environment :
3 Sites :
Site A: Primary site
 - consists of about 100 users
 - three ESXi Host servers
- about 40 Windows Virtual servers.
Site B: DR site
 - consists of 4 users
 - Consists of three ESXi hosts ( basically used to host the DR environment )
Site C: Remote site
 - Consists of 20 users
- Two domain controllers and file and print server
- Users connect back to Site A to work

I'm having a difficult time sizing my environment for System Center. I'm trying to use a minimal amount of servers for the System Center environment,  we are in a constant struggle to reduce the amount of servers. Too many servers end up being a support problem, maintenance is difficult and refreshing that many servers every few years to install a new OS is an ongoing issue,  Basically all of our servers are 2012 R2 and later, about a 50/50 split with 2012R2 and 2016.

I currently installed System Center 2016 Configuration Manager on  a Windows server 2016 and SQL Server 2014 on that same Server.

I'm now looking to install Operations Manager and was hoping Operations Manager Databases could use the same SQL server as Configuration Manager.  Is that OK ?

I guess my overall question is how would the experts install System Center in an Environment like mine, with the client requesting minimal amount of servers
How many Servers ? and which components on each server.

Also If I install on as few …
0
Is there a way to generate a report to show how many users are logged into your domain concurrently over a given amount of time?

We are considering converting to VDI - the platform we are considering is based on concurrent users. I want to view a figure over the past 3 months.
0
hello ,

i need sccm query to get the uptime for machines installed . anyone can help on provide this .

i have the below query and given syntax error :

SELECT
cs.Name0 AS 'ComputerName',
DATEDIFF(HOUR, os.LastBootUpTime0, ws.LastHWScan)
AS 'Uptime (in Hours)',
CONVERT(VARCHAR(26), os.LastBootUpTime0, 100)
AS 'Last Reboot Date/Time',
CONVERT(VARCHAR(26), ws.LastHWScan, 101)
AS 'Last Hardware Inventory'
FROM
dbo.v_GS_WORKSTATION_STATUS ws
LEFT OUTER JOIN dbo.v_GS_Operating_System os
ON ws.ResourceID = os.ResourceID
LEFT OUTER JOIN dbo.v_GS_COMPUTER_SYSTEM cs
ON cs.ResourceID = os.ResourceID
WHERE os.Caption0 LIKE '%server%'
ORDER BY os.LastBootUpTime0 ASC
0
Free Tool: Subnet Calculator
LVL 12
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

hello ,

i need sccm query to get the uptime for machines installed . anyone can help on provide this .

i have the below query and given syntax error :

SELECT
cs.Name0 AS ‘ComputerName’,
DATEDIFF(HOUR, os.LastBootUpTime0, ws.LastHWScan)
AS ‘Uptime (in Hours)’,
CONVERT(VARCHAR(26), os.LastBootUpTime0, 100)
AS ‘Last Reboot Date/Time’,
CONVERT(VARCHAR(26), ws.LastHWScan, 101)
AS ‘Last Hardware Inventory’
FROM
dbo.v_GS_WORKSTATION_STATUS ws
LEFT OUTER JOIN dbo.v_GS_Operating_System os
ON ws.ResourceID = os.ResourceID
LEFT OUTER JOIN dbo.v_GS_COMPUTER_SYSTEM cs
ON cs.ResourceID = os.ResourceID
WHERE os.Caption0 LIKE ‘%server%’
ORDER BY os.LastBootUpTime0 ASC
0
Hello - I am running SCCM 2012 R2 and when attempting to pull a list of Adobe updates (product) from filtering, I do not have Adobe listed as a product. Another tech that has been here longer mentioned that we needed some sort of plugin. Can you advise as to what I need to do to allow Adobe updates as a product list within SCCM?

Thank you so much.

nimdatx
0
Uninstall below two applications using SCCM

1.  Kaspersky End End Point Security 10 for Windows ( v10 and lower)
2.  Kaspersky Security Center 10 Network Agent ( v10 & Lower

using these keywords as few of the laptops may not have most recent versions.

how to achieve this.
sorry for asking broad question but its specific to particular application
0
We need to deploy a new Bios to HP machines without user intervention.  Can deploy with user intervention.  When using -s or -q it fails.  Need switches, or whatever.

Thanks!
0
Hi, I did some WMI troubleshooting on a Win10 Pro that was having trouble with the SCCM client installation.
After running the WMIDiag.vbs script from the WMI Diagnosis Utility 2.2 DL link (https://www.microsoft.com/en-us/download/details.aspx?id=7684), I ran this on an elevated command prompt:

dir /b *.mof *.mfl | findstr /v /i uninstall > moflist.txt & for /F %s in (moflist.txt) do mofcomp %s

I didn't notice that I was currently in the C:\Windows\System32 directory instead of a level deeper, in wbem. My bad.
I got the following output:

===========================================================================
C:\Windows\System32>dir /b *.mof *.mfl | findstr /v /i uninstall > moflist.txt & for /F %s in (moflist.txt) do mofcomp %s

C:\Windows\System32>mofcomp psmodulediscoveryprovider.mof
Microsoft (R) MOF Compiler Version 10.0.10240.16384
Copyright (c) Microsoft Corp. 1997-2006. All rights reserved.
Parsing MOF file: psmodulediscoveryprovider.mof
MOF file has been successfully parsed
Storing data in the repository...
Done!

C:\Windows\System32>mofcomp RestartManager.mof
Microsoft (R) MOF Compiler Version 10.0.10240.16384
Copyright (c) Microsoft Corp. 1997-2006. All rights reserved.
Parsing MOF file: RestartManager.mof
MOF file has been successfully parsed
Storing data in the repository...
WARNING: File RestartManager.mof does not contain #PRAGMA AUTORECOVER.
If the WMI repository is rebuilt in the future, the contents of this MOF file will not …
0
I'm looking for the Microsoft patch for the Microsoft Malware Protection Engine (CVE 2017-8540,8541). I'm in enterprise environment and not using WSUS, SCCM etc. I need to manually apply this patch but can not find the patch file. Please advise!  Thanks
0
Hi,
We are running SCCM 2012 CB 1710 with around 150 Windows 10 devices (Mainly SP4).
We are not pushing out Windows 10 Enterprise 1709 but we are finding random machines automatically upgrading to 1709. SCCM - Expiring SoonI believe this is to do with clients expiring soon - see attached screenshot.
Does anyone know how I stop clients automatically upgrading to 1709?

Thank you
0
Hello, Everyone, I found two very similar one-liners as part of the solution to WMI issues in SCCM client installation:

1.) from https://www.virtuallyboring.com/microsoft-wmi-invalid-class-error-0x80041010/
dir /b *.mof *.mfl | findstr /v /i uninstall > moflist.txt & for /F %s in (moflist.txt) do mofcomp %s

2.) from https://blogs.technet.microsoft.com/yongrhee/2016/06/23/wmi-stop-hurting-yourself-by-using-for-f-s-in-dir-s-b-mof-mfl-do-mofcomp-s/
dir /b *.mof *.mfl | findstr /v /i uninstall > moflist.txt & for /F %%s in (moflist.txt) do mofcomp %%s

What's the difference between the two? I used the line from link #2 (%%s), but I got the error "%%s was unexpected at this time."   I understand from other posts that using "%%s" in batch files will not yield errors.  When I used the line from link #1 (%s), the command ran.

If both lines get executed successfully, whether via CMD or BAT files, would they have the same end result?

Thank you very much.
0
Appreciate step by step guide on how we can use Solarwinds to

a) issue commands in batch (ie to all the hundreds of servers & Cisco devices)
    & collect back the outputs all in one file   : I used to have one HP central management tool that could do this

b) the OS commands I plan to send out are:
   Windows are :  "hostname; wmic qfe list"
   Solaris are     :  "uname -a; showrev -p"
   Cisco are       :  "hostname; show ver"

Our MS SCCM is used for PCs only so can't use it
0
Free Tool: ZipGrep
LVL 12
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

We have a working base image for Windows 10, and are able to deploy it using SCCM current branch and MDT 2013 (thanks largely to the guides on this web site).  We're now want to start testing the enabling of BitLocker when we deploy new computers. We're already setup BitLocker and are saving recovery keys to AD. We're been doing manual setups of laptops up to this point.

I see a "Enable BitLocker" (Run Command Line) task in the standard MDT task sequence that runs "%deployroot%\scripts\ZTIBde.wsf" if a task sequence variable exists. I don't know what this script is going to do.

However if I Add the Disk > Enable BitLocker task in the TS by hand, I get something completely different. This task is preferable since it's clear when you edit the TS that you know what it's going to do. Does this task assume TPM is already enabled? Is there a step that can confirm TPM is enabled, and if not, enable it?

What's the preferred way to enable BitLocker during image deployment?  Is there documentation, or anywhere else, that can help us with this?
0
Hello - I am in the process of planning and organizing our update deployments. I can see all All software updates and from 'Schedule Summarization' it looks as if it's being updated every hour. I am trying to filter all updates from this list and only gather all critical critical and critical important windows updates. In addition, I am trying to gather all adobe updates (critical). How can I filter this for a deployment? I am also wanting to make sure that no updates are deployed until I choose to pull trigger. How can I accomplish this?

Thanks,

nimdatx
0
Hi,
SCCM 2012 OSD Task Sequence fails to run  on three different types of computer
SCCMLog is attached
Any hint,advice
Thank you
smsts--003-.log
0
I have created SCCM (System Center Configuration Manager) server. I want to delete files that is created in SCCM server DP(Distribution Point) pcs. Is there any script to delete files in DP pcs? Because it is not easier to delete files from DP machines. I want delete files for older years. Everyday lots of updated file store at DP machines and local drive become full for some days. I have already found SCCM Content Library Cleanup Tool. But I cannot use that tool properly. Is there any script to delete files from specific date? Or Is there any alternative solution of that problem?
0
I have a sccm report that reports the statuscode and status message along with the application name and computername of a deployed application.  My problem is that the statuscode does not reflect the error in the appenforce.log.   If i run the built in report 'All application deployments (advanced)' supplied with sccm you can drill down (after several screens) to get the errors for the same deployment the errorcode matches what is in the appenforce.log.  I am not an experienced report writer and would like to know which tables I need to join to get the following:

Application Name, Computer Name, User Name, Errorcode (not statuscode), Error detail, Freespace, Total Size GB

Can anyone point me in the right direction.  Is there an explanation of sccm tables online somewhere?

Kind Regards,


Nigel
0
I work for an IT team in one of the departments at our organization. The organization purchased licenses for Adobe Acrobat DC recently and the central IT group had a meeting to show us how to use the Adobe Enterprise Portal to assign the licenses. These are subscription licenses which will be renewed annually. When we assign a license to a user, they get an email from Adobe with a link to download and install the product. They have to authenticate to download the installer (which really is just a link to download the installer). THEN after they install Acrobat DC and launch it, they have to authenticate again. Problem is, many users are not admins on their computers so our team got the actual install file (msi) and, using the Adobe Customization Wizard here

https://www.adobe.com/devnet-docs/acrobatetk/tools/Wizard/WizardDC/basics.html

made a customized installer we could push out with SCCM to the Windows computers we wanted to upgrade to Acrobat DC. Then we sent instructions to the user to launch DC and go through the registration/authentication process to use the product.

We also decided to customize the install file so it did NOT install the feature called "Send and Track" because we do not want our users to be sending attachments to the Adobe cloud. This all works on the Windows side.

We also have a Jamf Pro instance at our organization.

0

SCCM

688

Solutions

642

Contributors

Systems Center Configuration Manager (SCCM, formerly known as Systems Management Server) is Microsoft’s system software for managing large groups of not only Microsoft computers, but those running other operating systems, such as Linux, OS-X, and various mobile technologies.