Equivalent properties for the "License" & "Sign-in Status" inside SP user profile service

%3CLINGO-SUB%20id%3D%22lingo-sub-847176%22%20slang%3D%22en-US%22%3EEquivalent%20properties%20for%20the%20%22License%22%20%26amp%3B%20%22Sign-in%20Status%22%20inside%20SP%20user%20profile%20service%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-847176%22%20slang%3D%22en-US%22%3E%3CP%3EInside%20Office%20365%20active%20users%2C%20we%20depend%20on%204%20main%20properties%3A-%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E1.%20Username%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3E2.%20Licenses%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3E3.%20Office%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3E4.%20Sign-in%20Status%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eas%20follow%3A-%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F130987i285640F51AABFB01%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22activeusers.png%22%20title%3D%22activeusers.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3Ebut%20inside%20our%20sharepoint%20online%20user%20profile%20service%2C%20i%20am%20unable%20to%20find%20the%20equivalent%20properties%20for%20the%20%22Licenses%22%20and%20%22Sign-in%20Status%22%3F%20so%20does%20SP%20user%20profile%20service%20stores%20those%20info%3F%20if%20not%20then%20can%20we%20force%20it%20to%20do%20so%3F%20as%20in%20our%20case%20we%20have%20developed%20and%20also%20purchased%20some%203rd%20party%20tools%20which%20depend%20on%20the%20sharepoint%20user%20profile%20service's%20properties%2C%20and%20on%20some%20scenarios%20we%20want%20to%20exclude%20the%20users%20who%20are%20unlicensed%20or%20are%20been%20blocked%2C%20but%20i%20am%20unable%20to%20find%20the%20equivalent%20properties%20for%20this%20info%20inside%20SP%20user%20profile%20service%3F%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-847176%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EUser%20Profile%20Service%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-847416%22%20slang%3D%22en-US%22%3ERe%3A%20Equivalent%20properties%20for%20the%20%22License%22%20%26amp%3B%20%22Sign-in%20Status%22%20inside%20SP%20use%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-847416%22%20slang%3D%22en-US%22%3ENo%2C%20those%20properties%20are%20not%20present%20in%20SPO%20User%20Profiles%20and%20there%20is%20not%20a%20builtin%20way%20to%20do%20such%20syncrhonization.%20What%20you%20could%20do%20here%20is%20to%20create%20custom%20user%20profile%20properties%20in%20the%20SPO%20User%20Profiles%20and%20then%20create%20a%20PS%20scrit%20that%20run%20on%20a%20schedule%20and%20updates%20that%20info.%20to%20the%20custom%20properties%20you%20ahve%20created%20in%20the%20SPO%20User%20Profiles%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-847930%22%20slang%3D%22en-US%22%3ERe%3A%20Equivalent%20properties%20for%20the%20%22License%22%20%26amp%3B%20%22Sign-in%20Status%22%20inside%20SP%20use%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-847930%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F60%22%20target%3D%22_blank%22%3E%40Juan%20Carlos%20Gonz%C3%A1lez%20Mart%C3%ADn%3C%2FA%3EBut%20as%20i%20know%20in%20sharepoint%20online%20we%20can%20not%20create%20custom%20properties%20inside%20the%20user%20profile%20service%3F%20and%20when%20i%20tried%20to%20do%20so%20i%20found%20that%20those%20fields%20will%20be%20disabled%3A-%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20864px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F131061i32E2E3EA19631C14%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22addnewmap.png%22%20title%3D%22addnewmap.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-848068%22%20slang%3D%22en-US%22%3ERe%3A%20Equivalent%20properties%20for%20the%20%22License%22%20%26amp%3B%20%22Sign-in%20Status%22%20inside%20SP%20use%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-848068%22%20slang%3D%22en-US%22%3EI%20don't%20mean%20that%2C%20I%20mean%20you%20can%20add%20custom%20properties%20without%20doing%20a%20mapping%20and%20that%20custom%20properties%20can%20be%20updated%20using%20a%20PS%20Script...see%20this%3A%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsharepoint%2Fdev%2Fsolution-guidance%2Fbulk-user-profile-update-api-for-sharepoint-online%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsharepoint%2Fdev%2Fsolution-guidance%2Fbulk-user-profile-update-api-for-sharepoint-online%3C%2FA%3E%3C%2FLINGO-BODY%3E
Valued Contributor

Inside Office 365 active users, we depend on 4 main properties:-

 

1. Username

2. Licenses

3. Office

4. Sign-in Status

 

as follow:-

activeusers.png

but inside our sharepoint online user profile service, i am unable to find the equivalent properties for the "Licenses" and "Sign-in Status"? so does SP user profile service stores those info? if not then can we force it to do so? as in our case we have developed and also purchased some 3rd party tools which depend on the sharepoint user profile service's properties, and on some scenarios we want to exclude the users who are unlicensed or are been blocked, but i am unable to find the equivalent properties for this info inside SP user profile service?

Thanks

 

3 Replies
No, those properties are not present in SPO User Profiles and there is not a builtin way to do such syncrhonization. What you could do here is to create custom user profile properties in the SPO User Profiles and then create a PS scrit that run on a schedule and updates that info. to the custom properties you ahve created in the SPO User Profiles

@Juan Carlos González MartínBut as i know in sharepoint online we can not create custom properties inside the user profile service? and when i tried to do so i found that those fields will be disabled:-

addnewmap.png

I don't mean that, I mean you can add custom properties without doing a mapping and that custom properties can be updated using a PS Script...see this: https://docs.microsoft.com/en-us/sharepoint/dev/solution-guidance/bulk-user-profile-update-api-for-s...