Search the Community

Hello, comrades! I've created the report "Products from .exe files"- and it's working in a strange way. I.e. I'm looking for SW product '222'. OK, I find it on computers "aaa", "bbb", 'ccc'. Particulary, i find this file at '\\bbb\d$\install\222'. But on computer 'bbb' drive D have been changed a month ago and there the directory 'd:\Install' not exists at all. Is there a chance that "Software Inventory" are put to some kind of cache? Any ways do drop the cache? Thank you in advance! ---------------------------------------------- Script looks like this: ------------------------------------------------- SELECT DISTINCT SYS.Netbios_Name0, RIGHT(v_GS_SYSTEM_CONSOLE_USAGE.TopConsoleUser0, LEN(v_GS_SYSTEM_CONSOLE_USAGE.TopConsoleUser0) - 9) AS PrimaryUser, SP.CompanyName, SP.ProductName, MAX(SP.ProductVersion) AS ProductVersion, v_GS_NETWORK_ADAPTER_CONFIGURATION.IPAddress0 AS IPAddress, v_GS_SoftwareFile.FileName, v_GS_SoftwareFile.FileDescription, v_GS_SoftwareFile.FilePath, v_GS_LastSoftwareScan.LastScanDate FROM v_GS_SoftwareProduct AS SP INNER JOIN v_R_System AS SYS ON SP.ResourceID = SYS.ResourceID LEFT OUTER JOIN v_GS_SYSTEM_CONSOLE_USAGE ON SYS.ResourceID = v_GS_SYSTEM_CONSOLE_USAGE.ResourceID INNER JOIN v_GS_COMPUTER_SYSTEM ON v_GS_COMPUTER_SYSTEM.ResourceID = SYS.ResourceID INNER JOIN v_FullCollectionMembership AS fcm ON fcm.ResourceID = SYS.ResourceID INNER JOIN v_Collection AS Coll ON Coll.CollectionID = fcm.CollectionID AND Coll.Name = 'All Workstations' INNER JOIN v_GS_NETWORK_ADAPTER_CONFIGURATION ON SYS.ResourceID = v_GS_NETWORK_ADAPTER_CONFIGURATION.ResourceID INNER JOIN v_GS_SoftwareFile ON SP.ProductID = v_GS_SoftwareFile.ProductId INNER JOIN v_GS_LastSoftwareScan ON SYS.ResourceID = v_GS_LastSoftwareScan.ResourceID WHERE (SP.CompanyName LIKE '%222%') AND (v_GS_NETWORK_ADAPTER_CONFIGURATION.IPAddress0 IS NOT NULL) GROUP BY SYS.Netbios_Name0, RIGHT(v_GS_SYSTEM_CONSOLE_USAGE.TopConsoleUser0, LEN(v_GS_SYSTEM_CONSOLE_USAGE.TopConsoleUser0) - 9), SP.CompanyName, SP.ProductName, v_GS_NETWORK_ADAPTER_CONFIGURATION.IPAddress0, v_GS_SoftwareFile.FileName, v_GS_SoftwareFile.FileDescription, v_GS_SoftwareFile.FilePath, v_GS_LastSoftwareScan.LastScanDate

Hi, I've updated from 1610 to 1706 and i'm getting the below in both Parent and Child Sites for my CAS and 2 x Primary Sites. I've checked the logs and there are no errors so wondered if anyone else has came across this issue?

Hello Windows-noob, I've been tasked to build, configure, and implement SCCM in our environment. I've been watching (and reading) LOTS of tutorials on SCCM installation and dependencies. However, I can't find much resources on the different design/architectures for SCCM. I hear Windows-noob is the go-to place for SCCM. So here goes.. Here's an overview of our organization: Our organization is 300 Employees large and we have two data centers (different geographical location), with a 100MB connection that links both data centers. Location 1: Head Quarters, houses Data center Apha, 411 windows/linux servers (2DCs, 1WSUS) and Employees (275 laptops, unknown # of cellphones) Location 2: Data center Beta, 667 windows/linux servers (2DCs, 1WSUS) Here're my questions: What flavors of SCCM 2016 does MS offer? How's pricing calculated for each flavor? (I've visited the MS page, editions and pricing are not 100% clear to me) SCCM seems to come with lots of configurable features, what are most commonly used by most organization? (updates, os deployments,..etc) Based on the information provided above, what SCCM topology works best? Stand-alone Primary Site (Location A) with a Secondary site (Location B) or CAS with two Primary Sites? What route should we go for SCCM database (primary site & secondary site)? embedded (same server) vs shared (shared sql server) vs dedicated (it's own SQL server)? What type of impact from a networking stand point should we expect after SCCM has been successfully implemented? I really appreciate your input (including criticism) on any of the above.

Anyone going with SCCM CB on Server 2008 R2? We are currently running SCCM 2012 R2 CU2. I'm looking to deploy Windows 10 in our environment and our Server OS standard is 2008 R2. I realize that Win10 RTM and 1115 are still supported on 2012 (and I can deploy them fine) but my understanding is next Win10 CB won't. My questions are: Should I initially go with SCCM 2012 R2 SP1 and Win10 2015 LTSB to remain supported? Do the in place upgrade on 2008 R2 and just deal with the WSUS 3.0 issues? Perhaps, ask nicely to the server team for a Server 2012 R2 WSUS box. Wait for Server 2016 and do a side-by-side migration to SCCM CB?I leaning to waiting for Server 2016, and deploying Win 10 2015 LTSB. However, I'm curious on what everyone else is doing.