At times you'd like to be able to look more directly at the underlying SQL database that stores all your K1 SMA data. The video at:

https://www.youtube.com/watch?v=LRWbSu_vxQE

is a quick overview of how to do that, although a bit dated in the Spring of 2020.

For those who would like a printed HOWTO, here ya go.

First, make sure the SMA has that access turned on. Log into your SMA, and look under "Settings" / "Security Settings" and make sure that "Enable database access" is ticked.

wY0IkRbpkaIAAAAASUVORK5CYII=


You'll also need to know the name of the database, and the user who can log into that database. You'll find this at "Settings" / "General Settings":

The default database name is "ORG1" and the default Username is "R1" and the default password is "box747" (although it won't be showing in the password field).


Now you need a copy of MYSQL Workbench. The video shows you how to download it from Oracle's website for Windows, but I'm using Debian, so it's a simple matter of "apt install mysql-workbench" (but I did get a couple of "this version is not compatible with your database"-type warnings, which I clicked through without harm).

Then start MYSQL Workbench.

Click on the plus to add a new connection; name it something like "KACE_Browser".

Fill in the server name (something like "k1000.mycompany.org"), and the username ("R1", probably).

Everything else on these setup screens can probably be left at their defaults.

Click on "OK" to finish setting up the connection.

BD0ydHMSjITUzaAwCCCCAAAIIRIxAiMejTucQCkwjZuzpCAIIIIAAAggggEAAApoA8pAFAQQQQAABBBBAAIEqFyAwrXJSCkQAAQQQQAABBBAIRIDANBA18iCAAAIIIIAAAghUuQCBaZWTUiACCCCAAAIIIIBAIAIEpoGokQcBBBBAAAEEEECgygUITKuclAIRQAABBBBAAAEEAhEgMA1EjTwIIIAAAggggAACVS7wf8ZlW8hcARD8AAAAAElFTkSuQmCC

Now that you have your connection made, click on it to open it. You'll be asked for the password (see above).

EpArX2wAAAABJRU5ErkJggg==


rl5eX0A9xLgAABAgQIECBAgAABAgQIJAo4hSdxanomQIAAAQIECBAgQIAAAQIEWgUEKK3cihEgQIAAAQIECBAgQIAAAQKJAgKUxKnpmQABAgQIECBAgAABAgQIEGgVEKC0citGgAABAgQIECBAgAABAgQIJAoIUBKnpmcCBAgQIECAAAECBAgQIECgVUCA0sqtGAECBAgQIECAAAECBAgQIJAoIEBJnJqeCRAgQIAAAQIECBAgQIAAgVYBAUort2IECBAgQIAAAQIECBAgQIBAooAAJXFqeiZAgAABAgQIECBAgAABAgRaBQQordyKESBAgAABAgQIECBAgAABAokCApTEqemZAAECBAgQIECAAAECBAgQaBUQoLRyK0aAAAECBAgQIECAAAECBAgkCghQEqemZwIECBAgQIAAAQIECBAgQKBVQIDSyq0YAQIECBAgQIAAAQIECBAgkCggQEmcmp4JECBAgAABAgQIECBAgACBVgEBSiu3YgQIECBAgAABAgQIECBAgECigAAlcWp6JkCAAAECBAgQIECAAAECBFoFBCit3IoRIECAAAECBAgQIECAAAECiQIClMSp6ZkAAQIECBAgQIAAAQIECBBoFRCgtHIrRoAAAQIECBAgQIAAAQIECCQKCFASp6ZnAgQIECBAgAABAgQIECBAoFVAgNLKrRgBAgQIECBAgAABAgQIECCQKCBASZyangkQIECAAAECBAgQIECAAIFWAQFKK7diBAgQIECAAAECBAgQIECAQKKAACVxanomQIAAAQIECBAgQIAAAQIEWgUEKK3cihEgQIAAAQIECBAgQIAAAQKJAgKUxKnpmQABAgQIECBAgAABAgQIEGgVEKC0citGgAABAgQIECBAgAABAgQIJAoIUBKnpmcCBAgQIECAAAECBAgQIECgVUCA0sqtGAECBAgQIECAAAECBAgQIJAoIEBJnJqeCRAgQIAAAQIECBAgQIAAgVYBAUort2IECBAgQIAAAQIECBAgQIBAooAAJXFqeiZAgAABAgQIECBAgAABAgRaBQQordyKESBAgAABAgQIECBAgAABAokCApTEqemZAAECBAgQIECAAAECBAgQaBUQoLRyK0aAAAECBAgQIECAAAECBAgkCghQEqemZwIECBAgQIAAAQIECBAgQKBVQIDSyq0YAQIECBAgQIAAAQIECBAgkCggQEmcmp4JECBAgAABAgQIECBAgACBVgEBSiu3YgQIECBAgAABAgQIECBAgECigAAlcWp6JkCAAAECBAgQIECAAAECBFoFBCit3IoRIECAAAECBAgQIECAAAECiQIClMSp6ZkAAQIECBAgQIAAAQIECBBoFRCgtHIrRoAAAQIECBAgQIAAAQIECCQKCFASp6ZnAgQIECBAgAABAgQIECBAoFVAgNLKrRgBAgQIECBAgAABAgQIECCQKCBASZyangkQIECAAAECBAgQIECAAIFWAQFKK7diBAgQIECAAAECBAgQIECAQKKAACVxanomQIAAAQIECBAgQIAAAQIEWgUEKK3cihEgQIAAAQIECBAgQIAAAQKJAgKUxKnpmQABAgQIECBAgAABAgQIEGgVEKC0citGgAABAgQIECBAgAABAgQIJAoIUBKnpmcCBAgQIECAAAECBAgQIECgVUCA0sqtGAECBAgQIECAAAECBAgQIJAoIEBJnJqeCRAgQIAAAQIECBAgQIAAgVYBAUort2IECBAgQIAAAQIECBAgQIBAooAAJXFqeiZAgAABAgQIECBAgAABAgRaBQQordyKESBAgAABAgQIECBAgAABAokCApTEqemZAAECBAgQIECAAAECBAgQaBUQoLRyK0aAAAECBAgQIECAAAECBAgkCghQEqemZwIECBAgQIAAAQIECBAgQKBVQIDSyq0YAQIECBAgQIAAAQIECBAgkCggQEmcmp4JECBAgAABAgQIECBAgACBVgEBSiu3YgQIECBAgAABAgQIECBAgECigAAlcWp6JkCAAAECBAgQIECAAAECBFoFBCit3IoRIECAAAECBAgQIECAAAECiQIClMSp6ZkAAQIECBAgQIAAAQIECBBoFRCgtHIrRoAAAQIECBAgQIAAAQIECCQKCFASp6ZnAgQIECBAgAABAgQIECBAoFVAgNLKrRgBAgQIECBAgAABAgQIECCQKCBASZyangkQIECAAAECBAgQIECAAIFWgX8BHcHgNddYXYwAAAAASUVORK5CYII=


And, you're in!

PkKEEIAABCAAAQhAAAIQaG4B5AnNLY7xIAABCEAAAhCAAAQgYPwCyBOMfx8hQghAAAIQgAAEIAABCDS3wP8DCGwlnkOM2mQAAAAASUVORK5CYII=

In the left-hand pane, you can slide the title of that pane over to "Schemas"; most of your time will be spent in "ORG1", so you can right-click on that and select "Set as default schema".


Now, to get your feet wet just a tiny bit, open "ORG1" in the left-hand pane, then "Tables", then "MACHINE".

Right-click on "MACHINE" and click on "Select Rows - Limit 1000". This should show you the first 1000 of your devices in your K1 database. You'll notice it created a new tab at the top of the Query pane.

lgCGGW4TFmruIGrxB5H16ohLVxNTMxOzHssuMQjSfMOzAe1AAAgAASAABIAAEPhKCPwPVQ2G1MGL7fAAAAAASUVORK5CYII=


To modify this query, from "SELECT * FROM ORG1.MACHINE;", add between the word "MACHINE" and the colon a limiting WHERE statement, like so:

SELECT * FROM ORG1.MACHINE WHERE NAME = "BOBSPC";

Then click on the little lightning bolt ("Execute the query...")

Try another modification to your query, like so:

SELECT * FROM ORG1.MACHINE WHERE NAME LIKE "BOB%";

This should show all devices with a name that beings with "BOB".