Server Management - Systems Insight Manager
cancel
Showing results for 
Search instead for 
Did you mean: 

System Insight Manager site table query

 
SOLVED
Go to solution
Alice Seeley
Frequent Advisor

System Insight Manager site table query

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?

3 REPLIES
Ryan256
Advisor
Solution

Re: System Insight Manager site table query

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

Alice Seeley
Frequent Advisor

Re: System Insight Manager site table query

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

fjurewi2
Occasional Visitor

Re: System Insight Manager site table query

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