Global

lspci -v   look for: 1 PCI bridge: VMware  VGA compatible controller: VMware SVGA II Adapter (prog-if 00 [VGA contr 

Find API user personid,then: \copy (select p.id, p.text6, p.firstname, p.lastname, s2g.name AS acccesslevel,ptalgh.lastmod FROM person p JOIN s2activity.person_to_accesslevel_group_history ptalgh ON p.id=ptalgh.personid JOIN s2group s2g ON s2g.id=...

Upgrade Netbox to 6.2, get replication error in Global because of missing Honeywell VMS type Add missing VMS type to Global server: stage=> INSERT INTO stage_live.vmstype(vmstypeid,name) VALUES(15,'Honeywell'); Error will clear immediately ...

After upgrading to 6.0, Allina could no longer use the API to get people from the Global partition on that Netbox.  Fixed by running curl " http://localhost/nbws/properties/setbool? propertyName=s2sys.nbapi.nonlocal&value=true&persist=true " The ...

To Send Global Data to the NC: ============================ curl http://localhost/global/synchro/control/refresh/VMB70000001D96D827   To send NC data to Global: ================================== curl http://localhost/nbws/synchro/contro...

If /mnt/store2 runs out of space, you will see "out of space" messages in syslog and may get an error trying to save changes. This should be escalated to Fred, but he likes to see what he did the last time. df -h global=> SELECT schemaname, ind...

global=> select count(*), encoded_number FROM personinfo.access_cards GROUP BY 2 having count(*)>1; count | encoded_number -------+---------------- 2 | 166772 2 | 166118 2 | 166123 (3 rows) global=> BEGIN; BEGIN global=> delete from personinf...

If you get a hibernate error when clearing a login in global then make sure there are no alarms adopted by the user. 1- Select user_id from personinfo.users where person_id=xxxxx 2- Select * from transient_alarms where owner_id= 3- Delete from...

s2support@s2ncinit:/var/log/s2$ locate nbws.war /var/lib/tomcat8/webapps/nbws.war s2support@s2ncinit:/var/log/s2$ cd /var/lib/tomcat8/webapps/ s2support@s2ncinit:/var/lib/tomcat8/webapps$ ll total 70540 drwxr-xr-x 6 tomcat8 tomcat8 4096 Jan 2 11:4...