I need to export all the devices that we have into Spreadsheet, how can this be done?
The Traverse BVE API is the best way to get the desired set. An example that lists a device license category is List device license category
However, an alternate, real quick, way is to
* navigate to the Administration --> Devices (for the concerned Department)
* note the number of pages at the top right
* copying all text on the first page
* paste it first to Notepad
* "clean" the header and footer sections
* copy all the data from notepad
* copy to a spreadsheet tool such as Excel
* repeat the process for every page of devices
Again, the BVE API - http://help.kaseya.com/webhelp/EN/tv/9010000/dev/index.asp#home.htm - is the best way to extract this data. The above mechanism may be a quick fix for the reader that wants the data very quick.