# License Management

#### Who has what Salesforce License?

```
SELECT Id, Name, UserName, Profile.Name, Profile.UserLicense.MasterLabel
FROM User
WHERE IsActive = true
```

#### How Many Licenses do I have?

```
SELECT MasterLabel,MonthlyLoginsEntitlement,MonthlyLoginsUsed,Name,Status,TotalLicenses,UsedLicenses,UsedLicensesLastUpdated 
FROM UserLicense
```

#### How Many Managed Package Licenses do I have?

```
SELECT NamespacePrefix,Status,UsedLicenses,AllowedLicenses,ExpirationDate 
FROM PackageLicense
```

##### Who has what Managed Package License?

```
SELECT UserId, PackageLicense.NamespacePrefix, CreatedBy.Name,CreatedDate 
FROM UserPackageLicense
```

<p class="callout info">You must download this information and then do excel VLOOKUP or INDEX(MATCHES()) formula to join the data in excel.</p>

#### How many Permission Set Licenses do I have?

```
SELECT MasterLabel, DeveloperName, ExpirationDate,Status,TotalLicenses,UsedLicenses 
FROM PermissionSetLicense
```

#### Who has what Permission Set License?

```
SELECT Id, Assignee.Name, Assignee.UserName, PermissionSetLicense.MasterLabel
FROM PermissionSetLicenseAssign
WHERE Assignee.IsActive = true
```