- LANSWEEPER REPORT LAPTOPS PER DEPARTMENT DEPARTMENT UPDATE
- LANSWEEPER REPORT LAPTOPS PER DEPARTMENT DEPARTMENT FULL
In our case (We join V_R_System and v_GS_OFFICE365PROPLUSCONFIGURATIONS based on the same ResourceID) An SQL JOIN clause is used to combine rows from two tables, based on a common field between them. We need to use a JOIN SQL command to get it from the V_R_System view which is the “main” discovery view containing your clients. The machine name is not included in this view.
![lansweeper report laptops per department department lansweeper report laptops per department department](https://www.gizmochina.com/wp-content/uploads/2018/04/asus-logo.jpg)
Select * v_GS_OFFICE365PROPLUSCONFIGURATIONSīy looking at the results, we know that this is the right view to use. These classes are usually related to hardware inventory information.īy using a simple query we can see all data stored in this view:
![lansweeper report laptops per department department lansweeper report laptops per department department](https://rsload.net/images3/Lansweeper.5.0.0.763.png)
SCCM 1606 introduce a new way to inventory Office 365. A new inventory class is created on the client and this data is stored in the v_GS_OFFICE365PROPLUSCONFIGURATIONS. We found this view by browsing the v_GS_* classes in the SCCM database. For this example, we will show the process that we took when designing our free Office 365 report. Yes, they offer valuable data but they are often not adapted to your environment and are visually… basic.įor all those reasons, we started to create our own set of reports and due to their growing popularity, we decided to help you begin your own SCCM report creation process. In our opinion, the default SCCM Reports are lacking many of those points. Add tool tips to explain the data shown.Try to add links between your report to direct your reader in the right direction.
LANSWEEPER REPORT LAPTOPS PER DEPARTMENT DEPARTMENT UPDATE
Microsoft proves this with their latest Software Update dashboard and Office 365 dashboard. Try to keep it clean : add pie charts and graph if possible.
LANSWEEPER REPORT LAPTOPS PER DEPARTMENT DEPARTMENT FULL
A report full of data is useful but if it’s presented awfully, you won’t get readers attention.Two years ago I’ve never done a SCCM report and today we’ve build many and sells them to businesses like yours. Without any SQL skills, it will be hard to achieve what you want… but, everything can be learned.
![lansweeper report laptops per department department lansweeper report laptops per department department](https://citrixready.citrix.com/content/dam/ready/partners/la/lansweeper/lansweeper/lansweeper-pimage-images.png)