you need to know which data you want to pull from the database and then create a query to pull that data. You need to make a connection on the collector first off and then go to the GUI and create a new ODBC connection. I am just assuming it is a ODBC connection. You want to go to System Configuration > Services > Universal Device Collection > Manage ODBC Types. The "Name" has to be the same name as what you called your connection on the collector. Then fill in all the data needed (in Red) Next you need to got to System Configuration > Services > Device Services > Manage ODBC Services and create your connection. Once the devices shows up as Unknown then you can use your LSdata command to get your UNX file and use the ESI tool to make your XML.
I may be going about this the long way but this is how I created BMC Control SA.
Bob
