Notification

Icon
Error

Chart: Microsoft Office 365 Versions - Displays the different versions of Office 365 and the count

Posted: Wednesday, April 5, 2017 3:57:20 PM(UTC)
suspect0

suspect0

Member Original PosterPosts: 3
3
Like
It took me a while to get this working, mainly due to my lack of knowledge in doing these queries. This will grab the version number of the Office 365 installation and give the total amount of clients with that version. In turn it can be used for chart widgets.

Code:
Select Top 1000000 tblSoftware.softwareVersion,
  Count(tblAssets.AssetID) As Total,
  tblSoftware.softwareVersion As Version
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
  Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where tblSoftwareUni.softwareName Like '%microsoft office%365%' And
  tblAssetCustom.State = 1 And tblAssets.Assettype = -1
Group By tblSoftware.softwareVersion
Order By Version,
  Total Desc
Bruce.B
#1Bruce.B Member Administration Posts: 563  
posted: 4/10/2017 8:56:51 AM(UTC)
Slightly modified the report as you were selecting softwareversion twice

Code:
Select Top 1000000 tblSoftware.softwareVersion As Version,
  Count(tblAssets.AssetID) As Total
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
  Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where tblSoftwareUni.softwareName Like '%microsoft office%365%' And
  tblAssetCustom.State = 1 And tblAssets.Assettype = -1
Group By tblSoftware.softwareVersion,
  tblSoftwareUni.softwareName
Order By Version,
  Total Desc
studerje
#2studerje Member Posts: 7  
posted: 4/26/2017 3:59:03 PM(UTC)
This works great.
It would be really nice if you could click the version and have it take you to a list of computers running that version.
craigsmith.lpi
#3craigsmith.lpi Member Posts: 2  
posted: 10/19/2020 10:18:21 PM(UTC)
I also slightly tweaked the report to accommodate the app's name change to Microsoft 365 Apps. I think the syntax could be tweaked for efficiency, but this works.

Code:
Select Top 1000000 tblSoftware.softwareVersion As Version,
  Count(tblAssets.AssetID) As Total
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
  Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where (tblSoftwareUni.softwareName Like '%microsoft office%365%') Or
  (tblSoftwareUni.softwareName Like '%microsoft 365%' And tblAssetCustom.State =
  1 And tblAssets.Assettype = -1)
Group By tblSoftware.softwareVersion,
  tblSoftwareUni.softwareName
Order By Version,
  Total Desc


Active Discussions

Lansweeper Assigned Assets
by  anpatterson03   Go to last post Go to first unread
Last post: Yesterday at 11:50:46 PM(UTC)
Lansweeper Troubleshooting Helpdesk
by  brodiemac-too  
Go to last post Go to first unread
Last post: Yesterday at 8:46:21 PM(UTC)
Lansweeper Make agents regular users
by  JP-CPC   Go to last post Go to first unread
Last post: Yesterday at 7:32:54 PM(UTC)
Lansweeper Lansweeper updates without stopping whole IIS service
by  Hstr  
Go to last post Go to first unread
Last post: Yesterday at 10:32:17 AM(UTC)
Lansweeper Active Directory Groups not scanned properly
by  SCH   Go to last post Go to first unread
Last post: Yesterday at 7:10:23 AM(UTC)
Lansweeper Ticket Content Default Value
by  CPG  
Go to last post Go to first unread
Last post: 7/28/2021 8:45:12 PM(UTC)
Lansweeper New status to mimic Closed
by  chris.anderson   Go to last post Go to first unread
Last post: 7/28/2021 7:14:27 PM(UTC)
Lansweeper Change Management - Voting and Tracking
by  brodiemac-too  
Go to last post Go to first unread
Last post: 7/28/2021 2:48:01 PM(UTC)