Server Management - Systems Insight Manager
1748026 Members
3953 Online
108757 Solutions
New Discussion юеВ

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 3
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
New Member

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