topic Re: System Insight Manager site table query in Server Management - Systems Insight Manager

System Insight Manager site table query

Alice Seeley — Tue, 27 Aug 2013 16:04:35 GMT

I have a customer looking for someone that is knowledgeable in the System Insight Manager SQL database. He has over 300 sites and 6 SIM servers. He wants to be able to populate the locations in one SIM server and then export the site table to the other SIM servers so that he doesn't have to manually edit all the site locations. Does anyone have any idea where this site table might be located in SQL in SIM?

Re: System Insight Manager site table query

Ryan256 — Tue, 27 Aug 2013 18:48:46 GMT

I am assuming you are talking about this table dbo.SIM_SysCustomer

Re: System Insight Manager site table query

Alice Seeley — Tue, 27 Aug 2013 20:50:11 GMT

Yes, thank you. That was the table he was looking to find.

Re: System Insight Manager site table query

fjurewi2 — Thu, 29 Aug 2013 15:33:49 GMT

I need to add a list of sites in the proper format for SIM site table in to the SIM_SysCustomer table.

What is the query to insert it so it automatically assigns the key in the customerLuid field.

thank you