Getting information from SCCM servers without direct connection
We have a task to collect information from many sccm servers into one central SCCM server. The problem is that the servers cannot communicate directly (between servers only WMQ). Is there any way to make it?
June 25th, 2012 1:54am

We have a task to collect information from many sccm servers into one central SCCM server. The problem is that the servers cannot communicate directly (between servers only WMQ). Is there any way to make it? Collection information? Do you mean run Hardware Inventory on your SCCM servers and see the resulting data returned and viewable in reports at your Central? SCCM Clients do not need to speak to each other, Clients will contact their assigned sites default Management Point ...
Free Windows Admin Tool Kit Click here and download it now
June 25th, 2012 4:14am

I'm new in SCCM, that's why I may have some misunderstanding. I'll try explain more exactly what I really want. There are N departments. In each department we want to install SCCM server to run Hardware and Softrware Inventory. There is one main Departament which should aggregate Hardware and Software Inventory from all ohter departaments (central SCCM server). Main department can communicate with other only via WMQ. Is there any way to make it? Many thanks
June 25th, 2012 4:58am

This is not going to be a simple task. IMO This will take months to get Rev 1 going for this system. Before you go much farther you will need to define exactly what you want to see in Rev 1 of this system. You will then need to bring in both a High End SQL expert and a SCCM expert. The long a short answer is yes you can aggregate the data but you will need to be careful that it is done correctly.http://www.enhansoft.com/
Free Windows Admin Tool Kit Click here and download it now
June 25th, 2012 6:18am

Thanks for your reply Garth! I understand that this is a complicated task, but what is the best way to solve it? I think we can export information using SQL views for SCCM DB, send it via WMQ and import it in central SCCM server using MP API. How do you think, is it the right way or not?
June 25th, 2012 6:57am

It is not going to be that simple. You will end up by overwriting PCs data from another department, the last one in will win, therefore you cant just import them, you will need to transform them first. The question is what exactly do you need to know from each department for revision 1 of this system? Just ARP data? http://www.enhansoft.com/
Free Windows Admin Tool Kit Click here and download it now
June 25th, 2012 8:02am

Unfortunately English is not my native language, so I did not understand what means the ARP data. For the first revision we need show that this is possible to communicate between main and secondary deparment. For example, It would be enough to gather information about installed processors and some software.
June 25th, 2012 8:58am

Here's my suggestion, based upon your stated goal of departments having their own rights. Perhaps you haven't looked into the versions yet, but Configuration Manager 2007 is not the latest released version anymore. Configuration manager 2012 is. With version 2012, you should have just 1 site, and 1 main database. It may be true that you may need additional servers in those other departments--but not with their own database. Depending upon network bandwidth (maybe some department is across the ocean, via satellite link or something), perhaps a Secondary site and DP server are needed. The reason the one-site model will work for you, is because with Configuration Manager 2012 is that version has relatively easy to setup Role Based Administration. Otherwise, if you absolutely insist on Configuration Manager 2007 and multiple installations that do not talk to each other, the way to get those different databases to have 1 common reporting structure "can" (cough) be done. You'll need a Really, REALLY good sql database administrator, who understands SQL and SRS thoroughly, and can write (or rewrite) every single report you need to pull from the multiple databases. Note I say it 'can' be done... just to tell you it's possible. Almost no one in their right mind would do so. I strongly suggest you look at ConfigMgr 2012, a single site, and using the built-in RBA to designates rights.Standardize. Simplify. Automate.
Free Windows Admin Tool Kit Click here and download it now
June 25th, 2012 9:38am

ARP = Add/Remove Programs You cant merge multiple SCCM sites into one database like you have suggested. You will need to create your own data warehouse and populate it from all primary sites once you transform the data.http://www.enhansoft.com/
June 25th, 2012 9:58am

May I suggest that neither SCCM 2007 or 2012 are a change management database and that you rather invest in looking at System Center Service Manager to aggregate all the data from each environment? I think this is a better location for this sort of data and has been built with gathering standard and custom data from all sorts of locations. What is not clear is what you want to do with the data once it has been gathered centrally. If it is purely for auditing and change management then SCSM is definately the way to go. You can relatively easily create connectors to import the data into SCSM.
Free Windows Admin Tool Kit Click here and download it now
June 25th, 2012 4:29pm

Perhaps you haven't looked into the versions yet, but Configuration Manager 2007 is not the latest released version anymore. Configuration manager 2012 is. With version 2012, you should have just 1 site, and 1 main database. It may be true that you may need additional servers in those other departments--but not with their own database. Depending upon network bandwidth (maybe some department is across the ocean, via satellite link or something), perhaps a Secondary site and DP server are needed. The problem is we have only windows server 2003 in our departments. As I know SCCM 2012 requires at least windows server 2008. Nevertheless I'll look at SCCM 2012 more attentively. If it is purely for auditing and change management then SCSM is definately the way to go. You can relatively easily create connectors to import the data into SCSM. Yes, right now it just for auditing and change management.
June 26th, 2012 7:22am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics