filter only licenses imported from 0365

[ImIronMan]

Hi Team

Is there a way that we can filter licenses or Apps or Users that are coming only from 0365 adapter ?

Currently we have thousands of licenses, users, apps and finding difficulty to get a clarity on source of data

Regards

Rajesh Ponnala

#O365

#Microsoft

[mfranz]

Rajesh,

By "filter", do you mean excluding part of the data from being imported? Or do you want to be able to track the source of the data in the WebUI?

1. If you want to omit part of the data, you could try to change the reader.
2. if you want to add additional data, you could look at:

• ImportedSoftwareLicense for licenses and where they were comming from (ComplianceConnectionID)
• ImportedUser for users and where they were comming from (ComplianceConnectionID)

Using a business import, you could update some custom fields to mark the source of the data.

Best regards,

Markward

[AamerSharif · Accepted solution]

Hi Rajesh,

All Licenses grid would not let you easily filter as you will have lots of other licenses for publisher Microsoft and license type named user.

There is one option within the FNMS, you can use to filter all the licenses imported/created from O365 portal using O365 connector.

If you use report build and build report for object License and select  Part no./SKU and apply advance filter begin with FLX-O365

This will give you all the license created/imported from Microsoft O365 portal.

HTH

Aamer 

[winvarma]

Hi @AamerSharif ,

i've tried the steps you suggested but couldn't find such options can you pls provide any snapshots of the same for better understanding on this.

Regards

Winvarma

[kclausen]

There is not an easy way to accomplish this.  One of the recommendations was to use SQL, which would not be an option for FNMS Cloud.

The closest you can come using built-in filters would be to go to the All Licenses view and make sure that "Duration" is added as a column.  Then, find all of your Microsoft licenses where the license type is Named User and the duration is Subscription.  From this, you would want to ignore your MSDN licenses.  What remains would be your Office 365 licenses, but the list is not perfect and may included other Named User subscription licenses that are not for Office 365.