Can somebody help me to create a Kace1000 SQL Report ?
My problem is I do not know SQL and Kace 1000 v 6.0 reporting does not connect Asset types. I have a group of assets in Asset type Cost Center 7000. These were assets purchased after 2/1/2014. Each month I have to run a report what assets changed to different cost centers along with the dollars. Right now it I have been creating 4 separate reports for different Asset Types. Computer, Misc Hardware and Peripherals,Network devices (routers,switches,telephones) and printers. All 4 asset types have the same fields to pull from - Serial or Service tag, Make Model, total purchase price,cost center, and date purchased.
If I cannot create a SQL report my last resort will be is to combine all the above types into 1 type to make it work. Any help will be greatly appeciated