×Sorry to interruptThis page has an error. You might just need to refresh it.
Unable to find an action for 170;a: {"id":"170;a","state":"SUCCESS","returnValue":{"isTopicsEnabled":true,"isThreadedEnabled":true,"contextualMessages":[],"feedItem":{"actor":{"additionalLabel":"Customer","communityNickname":"RobertYoung79390","companyName":null,"displayName":"RobertYoung79390","firstName":null,"id":"0054u000009LAOaAAO","isActive":true,"isInThisCommunity":true,"lastName":null,"motif":{"color":"1B96FF","largeIconUrl":"/img/icon/t4v35/standard/user_120.png","mediumIconUrl":"/img/icon/t4v35/standard/user_60.png","smallIconUrl":"/img/icon/t4v35/standard/user_60.png","svgIconUrl":"/img/icon/t4v35/standard/user.svg"},"mySubscription":null,"name":"RobertYoung79390","outOfOffice":{"message":""},"photo":{"fullEmailPhotoUrl":"https://community.securid.com/img/userprofile/default_profile_200_v2.png?fromEmail=1","largePhotoUrl":"https://community.securid.com/img/userprofile/default_profile_200_v2.png","mediumPhotoUrl":"https://community.securid.com/img/userprofile/default_profile_160_v2.png","photoVersionId":null,"smallPhotoUrl":"https://community.securid.com/img/userprofile/default_profile_45_v2.png","standardEmailPhotoUrl":"https://community.securid.com/img/userprofile/default_profile_45_v2.png?fromEmail=1","url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/user-profiles/0054u000009LAOaAAO/photo"},"reputation":{"reputationLevel":{"levelImageUrl":"/img/reputation/levelicons/reputation_level_01.png","levelName":"Beginner","levelNumber":1},"reputationPoints":18,"url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/users/0054u000009LAOa/reputation"},"title":null,"type":"User","url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/users/0054u000009LAOaAAO","userType":"Portal"},"body":{"isRichText":true,"messageSegments":[{"altText":null,"htmlTag":"p","markupType":"Paragraph","text":"","type":"MarkupBegin","url":null},{"text":"We have circumstances where the Last Login Date collected is blank. The collector is expecting a Date. Is there any manner in which to set it as NULL or do we need to pick a dummy date to represent that?","type":"Text"},{"htmlTag":"p","markupType":"Paragraph","text":"\n","type":"MarkupEnd"}],"text":"We have circumstances where the Last Login Date collected is blank. The collector is expecting a Date. Is there any manner in which to set it as NULL or do we need to pick a dummy date to represent that?\n"},"capabilities":{"associatedActions":{"platformActionGroups":[]},"bookmarks":{"isBookmarkedByCurrentUser":false},"chatterLikes":{"isLikedByCurrentUser":false,"likesMessage":null,"myLike":null,"page":{"currentPageToken":0,"currentPageUrl":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/feed-elements/0D5PO00000L2yAW0AZ/capabilities/chatter-likes/items","items":[],"nextPageToken":null,"nextPageUrl":null,"previousPageToken":null,"previousPageUrl":null,"total":0}},"close":{"canContextUserUpdateIsClosed":false,"isClosed":false},"comments":{"page":{"currentPageToken":null,"currentPageUrl":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/feed-elements/0D5PO00000L2yAW0AZ/capabilities/comments/items?sort=CreatedDateOldestAsc","items":[{"body":{"isRichText":true,"messageSegments":[{"altText":null,"htmlTag":"p","markupType":"Paragraph","text":"","type":"MarkupBegin","url":null},{"text":"Hi Robert,","type":"Text"},{"htmlTag":"p","markupType":"Paragraph","text":"\n","type":"MarkupEnd"},{"altText":null,"htmlTag":"p","markupType":"Paragraph","text":"","type":"MarkupBegin","url":null},{"text":" ","type":"Text"},{"htmlTag":"p","markupType":"Paragraph","text":"\n","type":"MarkupEnd"},{"altText":null,"htmlTag":"p","markupType":"Paragraph","text":"","type":"MarkupBegin","url":null},{"text":"Can you clarify a bit more the situation? You are collecting a date attribute/value but you want it to presented as NULL in RSA GL? ","type":"Text"},{"htmlTag":"p","markupType":"Paragraph","text":"\n","type":"MarkupEnd"},{"altText":null,"htmlTag":"p","markupType":"Paragraph","text":"","type":"MarkupBegin","url":null},{"text":"What is the desired behavior?","type":"Text"},{"htmlTag":"p","markupType":"Paragraph","text":"\n","type":"MarkupEnd"},{"altText":null,"htmlTag":"p","markupType":"Paragraph","text":"","type":"MarkupBegin","url":null},{"text":"What type of collector you are using (JDBC/LDAP/API)?","type":"Text"},{"htmlTag":"p","markupType":"Paragraph","text":"\n","type":"MarkupEnd"},{"altText":null,"htmlTag":"p","markupType":"Paragraph","text":"","type":"MarkupBegin","url":null},{"text":"What version of RSA GL? ","type":"Text"},{"htmlTag":"p","markupType":"Paragraph","text":"\n","type":"MarkupEnd"},{"altText":null,"htmlTag":"p","markupType":"Paragraph","text":"","type":"MarkupBegin","url":null},{"text":" ","type":"Text"},{"htmlTag":"p","markupType":"Paragraph","text":"\n","type":"MarkupEnd"}],"text":"Hi Robert,\n \nCan you clarify a bit more the situation? You are collecting a date attribute/value but you want it to presented as NULL in RSA GL? \nWhat is the desired behavior?\nWhat type of collector you are using (JDBC/LDAP/API)?\nWhat version of RSA GL? \n \n"},"capabilities":{"comments":{"page":{"currentPageToken":null,"currentPageUrl":null,"items":[],"nextPageToken":null,"nextPageUrl":null,"previousPageToken":null,"previousPageUrl":null,"total":0}},"edit":{"isEditRestricted":true,"isEditableByMeUrl":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/comments/0D7PO000002hrkf0AA/capabilities/edit/is-editable-by-me","lastEditedBy":null,"lastEditedDate":null,"latestRevision":1,"relativeLastEditedDate":null},"status":{"feedEntityStatus":"Published","isApprovableByMe":false},"upDownVote":{"downVoteCount":0,"myVote":"None","upVoteCount":0},"verified":{"isVerifiableByMe":false,"isVerified":false,"isVerifiedByAnonymized":null,"lastVerifiedByUser":null,"lastVerifiedDate":null}},"clientInfo":null,"createdDate":"2024-08-30T00:17:00.000Z","feedElement":{"id":"0D5PO00000L2yAW0AZ","url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/feed-elements/0D5PO00000L2yAW0AZ"},"id":"0D7PO000002hrkf0AA","isDeleteRestricted":true,"likes":{"currentPageToken":null,"currentPageUrl":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/comments/0D7PO000002hrkf0AA/likes","items":[],"nextPageToken":null,"nextPageUrl":null,"previousPageToken":null,"previousPageUrl":null,"total":0},"likesMessage":null,"moderationFlags":{"flagCount":null,"flagCountByReason":{"FlaggedByRule":null,"FlaggedBySystem":null,"FlaggedByUserAsSpam":null,"FlaggedByUserAsInappropriate":null},"flaggedByMe":false,"flags":{"currentPageToken":null,"currentPageUrl":null,"flags":[],"nextPageToken":null,"nextPageUrl":null,"pageSize":null}},"myLike":null,"parent":{"id":"0054u000009LAOaAAO","url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/users/0054u000009LAOaAAO"},"relativeCreatedDate":"August 30, 2024 at 12:17 AM","threadLevel":0,"threadParentId":null,"type":"TextComment","url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/comments/0D7PO000002hrkf0AA","user":{"additionalLabel":"RSA","communityNickname":"Boris.Lekumovich","companyName":null,"displayName":"Boris.Lekumovich","firstName":null,"id":"00570000001U0GXAA0","isActive":true,"isInThisCommunity":true,"lastName":null,"motif":{"color":"1B96FF","largeIconUrl":"/img/icon/t4v35/standard/user_120.png","mediumIconUrl":"/img/icon/t4v35/standard/user_60.png","smallIconUrl":"/img/icon/t4v35/standard/user_60.png","svgIconUrl":"/img/icon/t4v35/standard/user.svg"},"mySubscription":null,"name":"Boris.Lekumovich","outOfOffice":{"message":""},"photo":{"fullEmailPhotoUrl":"https://community.securid.com/ncsphoto/UvsFQBOAp_JHaxfhtemq-vMXnkR4DpgkdNbmbAu9HK3IKnr98V_DEF7LQN-VrXJV?fromEmail=1","largePhotoUrl":"https://community.securid.com/ncsphoto/UvsFQBOAp_JHaxfhtemq-vMXnkR4DpgkdNbmbAu9HK3IKnr98V_DEF7LQN-VrXJV","mediumPhotoUrl":"https://community.securid.com/ncsphoto/UvsFQBOAp_JHaxfhtemq-vMXnkR4DpgkdNbmbAu9HK0OnK6vqB5VAzvNsyw-ACZY","photoVersionId":"729PO000002oq0fYAA","smallPhotoUrl":"https://community.securid.com/ncsphoto/UvsFQBOAp_JHaxfhtemq-vMXnkR4DpgkdNbmbAu9HK2BxIvkoyO75t0sir59ne4u","standardEmailPhotoUrl":"https://community.securid.com/ncsphoto/UvsFQBOAp_JHaxfhtemq-vMXnkR4DpgkdNbmbAu9HK2BxIvkoyO75t0sir59ne4u?fromEmail=1","url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/user-profiles/00570000001U0GXAA0/photo"},"reputation":{"reputationLevel":{"levelImageUrl":"/img/reputation/levelicons/reputation_level_05.png","levelName":"Dedicated","levelNumber":5},"reputationPoints":1386,"url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/users/00570000001U0GX/reputation"},"title":null,"type":"User","url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/users/00570000001U0GXAA0","userType":"Internal"}},{"body":{"isRichText":true,"messageSegments":[{"altText":null,"htmlTag":"p","markupType":"Paragraph","text":"","type":"MarkupBegin","url":null},{"text":"Title is confusing, because if you want null, and date is blank, you will get null (no matter which type it is)","type":"Text"},{"htmlTag":"p","markupType":"Paragraph","text":"\n","type":"MarkupEnd"},{"altText":null,"htmlTag":"p","markupType":"Paragraph","text":"","type":"MarkupBegin","url":null},{"text":" ","type":"Text"},{"htmlTag":"p","markupType":"Paragraph","text":"\n","type":"MarkupEnd"},{"altText":null,"htmlTag":"p","markupType":"Paragraph","text":"","type":"MarkupBegin","url":null},{"text":" ","type":"Text"},{"htmlTag":"p","markupType":"Paragraph","text":"\n","type":"MarkupEnd"},{"altText":null,"htmlTag":"p","markupType":"Paragraph","text":"","type":"MarkupBegin","url":null},{"text":"So doing an answer on the opposite: ","type":"Text"},{"altText":null,"htmlTag":"b","markupType":"Bold","text":"","type":"MarkupBegin","url":null},{"text":"I guess you want to collect Last Login Date?","type":"Text"},{"htmlTag":"b","markupType":"Bold","text":"","type":"MarkupEnd"},{"htmlTag":"p","markupType":"Paragraph","text":"\n","type":"MarkupEnd"},{"altText":null,"htmlTag":"p","markupType":"Paragraph","text":"","type":"MarkupBegin","url":null},{"text":"To be able to collect a Last Login Date, you need a collector that understands this \"as a date\".","type":"Text"},{"htmlTag":"p","markupType":"Paragraph","text":"\n","type":"MarkupEnd"},{"altText":null,"htmlTag":"p","markupType":"Paragraph","text":"","type":"MarkupBegin","url":null},{"text":" ","type":"Text"},{"htmlTag":"p","markupType":"Paragraph","text":"\n","type":"MarkupEnd"},{"altText":null,"htmlTag":"p","markupType":"Paragraph","text":"","type":"MarkupBegin","url":null},{"text":"LDAP-connectores (like the Windows one) are able to collect dates from AD, but there is no support for \"input transformation\". ","type":"Text"},{"htmlTag":"p","markupType":"Paragraph","text":"\n","type":"MarkupEnd"},{"altText":null,"htmlTag":"p","markupType":"Paragraph","text":"","type":"MarkupBegin","url":null},{"text":"This product only supports \"output transformation\" where an IDC synchronizes what has been read in. ","type":"Text"},{"htmlTag":"p","markupType":"Paragraph","text":"\n","type":"MarkupEnd"},{"altText":null,"htmlTag":"p","markupType":"Paragraph","text":"","type":"MarkupBegin","url":null},{"text":"But guessing you are talking about an ADC here, and then you need the Last Login Date field to be collected AS date (this due to it being used in reviews, to find accounts not logged in for a while)","type":"Text"},{"htmlTag":"p","markupType":"Paragraph","text":"\n","type":"MarkupEnd"},{"altText":null,"htmlTag":"p","markupType":"Paragraph","text":"","type":"MarkupBegin","url":null},{"text":" ","type":"Text"},{"htmlTag":"p","markupType":"Paragraph","text":"\n","type":"MarkupEnd"},{"altText":null,"htmlTag":"p","markupType":"Paragraph","text":"","type":"MarkupBegin","url":null},{"text":"So guessing here (you didn't give much info) I am guessing you have two paths:","type":"Text"},{"htmlTag":"p","markupType":"Paragraph","text":"\n","type":"MarkupEnd"},{"altText":null,"htmlTag":"ul","markupType":"UnorderedList","text":"","type":"MarkupBegin","url":null},{"altText":null,"htmlTag":"li","markupType":"ListItem","text":"- ","type":"MarkupBegin","url":null},{"text":"1) Find a way to make the (LDAP/REST) collector read the Last Login Date as date","type":"Text"},{"altText":null,"htmlTag":"ul","markupType":"UnorderedList","text":"","type":"MarkupBegin","url":null},{"altText":null,"htmlTag":"li","markupType":"ListItem","text":"- ","type":"MarkupBegin","url":null},{"text":"could be a entitlement issue. Maybe your application account don't have \"rights to read\" that attribute (often being an operational attribute)","type":"Text"},{"htmlTag":"li","markupType":"ListItem","text":"\n","type":"MarkupEnd"},{"htmlTag":"ul","markupType":"UnorderedList","text":"","type":"MarkupEnd"},{"htmlTag":"li","markupType":"ListItem","text":"\n","type":"MarkupEnd"},{"altText":null,"htmlTag":"li","markupType":"ListItem","text":"- ","type":"MarkupBegin","url":null},{"text":"2) Worst case: You need to use a SQL-based collector, which allows you to convert any of the incoming attributes to date.","type":"Text"},{"altText":null,"htmlTag":"ul","markupType":"UnorderedList","text":"","type":"MarkupBegin","url":null},{"altText":null,"htmlTag":"li","markupType":"ListItem","text":"- ","type":"MarkupBegin","url":null},{"text":"this scenario seems to need a product (an \"integration tool\") in between","type":"Text"},{"altText":null,"htmlTag":"ul","markupType":"UnorderedList","text":"","type":"MarkupBegin","url":null},{"altText":null,"htmlTag":"li","markupType":"ListItem","text":"- ","type":"MarkupBegin","url":null},{"text":"like ","type":"Text"},{"text":"teiid.io","type":"Link","url":"https://teiid.io"},{"text":" or ","type":"Text"},{"text":"tdi-users.org","type":"Link","url":"https://tdi-users.org"},{"htmlTag":"li","markupType":"ListItem","text":"\n","type":"MarkupEnd"},{"altText":null,"htmlTag":"li","markupType":"ListItem","text":"- ","type":"MarkupBegin","url":null},{"text":"these products then have the option to \"present true NULL\" to any system ","type":"Text"},{"altText":null,"htmlTag":"ul","markupType":"UnorderedList","text":"","type":"MarkupBegin","url":null},{"altText":null,"htmlTag":"li","markupType":"ListItem","text":"- ","type":"MarkupBegin","url":null},{"text":"although: for most collectors (LDAP/REST especially) \"empty string\" is treated same as NULL","type":"Text"},{"htmlTag":"li","markupType":"ListItem","text":"\n","type":"MarkupEnd"},{"htmlTag":"ul","markupType":"UnorderedList","text":"","type":"MarkupEnd"},{"htmlTag":"li","markupType":"ListItem","text":"\n","type":"MarkupEnd"},{"htmlTag":"ul","markupType":"UnorderedList","text":"","type":"MarkupEnd"},{"htmlTag":"li","markupType":"ListItem","text":"\n","type":"MarkupEnd"},{"altText":null,"htmlTag":"li","markupType":"ListItem","text":"- ","type":"MarkupBegin","url":null},{"text":"where this solution is more complicated, but give better solutions for say an LDAP-directory:","type":"Text"},{"altText":null,"htmlTag":"ul","markupType":"UnorderedList","text":"","type":"MarkupBegin","url":null},{"altText":null,"htmlTag":"li","markupType":"ListItem","text":"- ","type":"MarkupBegin","url":null},{"text":"In LDAP the \"last login\" is only created on that particular local server when the BIND happened","type":"Text"},{"htmlTag":"li","markupType":"ListItem","text":"\n","type":"MarkupEnd"},{"altText":null,"htmlTag":"li","markupType":"ListItem","text":"- ","type":"MarkupBegin","url":null},{"text":"Meaning: To get a \"real last login\" you need to collect all last logins from all servers in the cluster, and then present the \"newest\"","type":"Text"},{"altText":null,"htmlTag":"ul","markupType":"UnorderedList","text":"","type":"MarkupBegin","url":null},{"altText":null,"htmlTag":"li","markupType":"ListItem","text":"- ","type":"MarkupBegin","url":null},{"text":"this can only be done with more advanced data handlers like ","type":"Text"},{"text":"teiid.io","type":"Link","url":"https://teiid.io"},{"text":" or ","type":"Text"},{"text":"tdi-users.org","type":"Link","url":"https://tdi-users.org"},{"htmlTag":"li","markupType":"ListItem","text":"\n","type":"MarkupEnd"},{"htmlTag":"ul","markupType":"UnorderedList","text":"","type":"MarkupEnd"},{"htmlTag":"li","markupType":"ListItem","text":"\n","type":"MarkupEnd"},{"htmlTag":"ul","markupType":"UnorderedList","text":"","type":"MarkupEnd"},{"htmlTag":"li","markupType":"ListItem","text":"\n","type":"MarkupEnd"},{"htmlTag":"ul","markupType":"UnorderedList","text":"","type":"MarkupEnd"},{"htmlTag":"li","markupType":"ListItem","text":"\n","type":"MarkupEnd"},{"htmlTag":"ul","markupType":"UnorderedList","text":"","type":"MarkupEnd"},{"altText":null,"htmlTag":"p","markupType":"Paragraph","text":"","type":"MarkupBegin","url":null},{"text":" ","type":"Text"},{"htmlTag":"p","markupType":"Paragraph","text":"\n","type":"MarkupEnd"},{"altText":null,"htmlTag":"p","markupType":"Paragraph","text":"","type":"MarkupBegin","url":null},{"text":"In summary NULL-problems are always complicated, and will stop talking now. But there are 7 different places in the product which treats NULL differently.","type":"Text"},{"htmlTag":"p","markupType":"Paragraph","text":"\n","type":"MarkupEnd"}],"text":"Title is confusing, because if you want null, and date is blank, you will get null (no matter which type it is)\n \n \nSo doing an answer on the opposite: I guess you want to collect Last Login Date?\nTo be able to collect a Last Login Date, you need a collector that understands this \"as a date\".\n \nLDAP-connectores (like the Windows one) are able to collect dates from AD, but there is no support for \"input transformation\". \nThis product only supports \"output transformation\" where an IDC synchronizes what has been read in. \nBut guessing you are talking about an ADC here, and then you need the Last Login Date field to be collected AS date (this due to it being used in reviews, to find accounts not logged in for a while)\n \nSo guessing here (you didn't give much info) I am guessing you have two paths:\n- 1) Find a way to make the (LDAP/REST) collector read the Last Login Date as date- could be a entitlement issue. Maybe your application account don't have \"rights to read\" that attribute (often being an operational attribute)\n\n- 2) Worst case: You need to use a SQL-based collector, which allows you to convert any of the incoming attributes to date.- this scenario seems to need a product (an \"integration tool\") in between- like teiid.io or tdi-users.org\n- these products then have the option to \"present true NULL\" to any system - although: for most collectors (LDAP/REST especially) \"empty string\" is treated same as NULL\n\n\n- where this solution is more complicated, but give better solutions for say an LDAP-directory:- In LDAP the \"last login\" is only created on that particular local server when the BIND happened\n- Meaning: To get a \"real last login\" you need to collect all last logins from all servers in the cluster, and then present the \"newest\"- this can only be done with more advanced data handlers like teiid.io or tdi-users.org\n\n\n\n \nIn summary NULL-problems are always complicated, and will stop talking now. But there are 7 different places in the product which treats NULL differently.\n"},"capabilities":{"comments":{"page":{"currentPageToken":null,"currentPageUrl":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/comments/0D7PO000002hutp0AA/capabilities/comments/items","items":[],"nextPageToken":null,"nextPageUrl":null,"previousPageToken":null,"previousPageUrl":null,"total":1}},"edit":{"isEditRestricted":true,"isEditableByMeUrl":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/comments/0D7PO000002hutp0AA/capabilities/edit/is-editable-by-me","lastEditedBy":null,"lastEditedDate":null,"latestRevision":1,"relativeLastEditedDate":null},"status":{"feedEntityStatus":"Published","isApprovableByMe":false},"upDownVote":{"downVoteCount":0,"myVote":"None","upVoteCount":1},"verified":{"isVerifiableByMe":false,"isVerified":false,"isVerifiedByAnonymized":null,"lastVerifiedByUser":null,"lastVerifiedDate":null}},"clientInfo":null,"createdDate":"2024-08-30T10:15:31.000Z","feedElement":{"id":"0D5PO00000L2yAW0AZ","url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/feed-elements/0D5PO00000L2yAW0AZ"},"id":"0D7PO000002hutp0AA","isDeleteRestricted":true,"likes":{"currentPageToken":0,"currentPageUrl":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/comments/0D7PO000002hutp0AA/likes","items":[{"id":"0I0PO000000sJs50AE","likedItem":{"id":"0D7PO000002hutp0AA","url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/comments/0D7PO000002hutp0AA"},"url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/likes/0I0PO000000sJs50AE","user":{"additionalLabel":"RSA","communityNickname":"Boris.Lekumovich","companyName":null,"displayName":"Boris.Lekumovich","firstName":null,"id":"00570000001U0GXAA0","isActive":true,"isInThisCommunity":true,"lastName":null,"motif":{"color":"1B96FF","largeIconUrl":"/img/icon/t4v35/standard/user_120.png","mediumIconUrl":"/img/icon/t4v35/standard/user_60.png","smallIconUrl":"/img/icon/t4v35/standard/user_60.png","svgIconUrl":"/img/icon/t4v35/standard/user.svg"},"mySubscription":null,"name":"Boris.Lekumovich","outOfOffice":{"message":""},"photo":{"fullEmailPhotoUrl":"https://community.securid.com/ncsphoto/UvsFQBOAp_JHaxfhtemq-vMXnkR4DpgkdNbmbAu9HK3IKnr98V_DEF7LQN-VrXJV?fromEmail=1","largePhotoUrl":"https://community.securid.com/ncsphoto/UvsFQBOAp_JHaxfhtemq-vMXnkR4DpgkdNbmbAu9HK3IKnr98V_DEF7LQN-VrXJV","mediumPhotoUrl":"https://community.securid.com/ncsphoto/UvsFQBOAp_JHaxfhtemq-vMXnkR4DpgkdNbmbAu9HK0OnK6vqB5VAzvNsyw-ACZY","photoVersionId":"729PO000002oq0fYAA","smallPhotoUrl":"https://community.securid.com/ncsphoto/UvsFQBOAp_JHaxfhtemq-vMXnkR4DpgkdNbmbAu9HK2BxIvkoyO75t0sir59ne4u","standardEmailPhotoUrl":"https://community.securid.com/ncsphoto/UvsFQBOAp_JHaxfhtemq-vMXnkR4DpgkdNbmbAu9HK2BxIvkoyO75t0sir59ne4u?fromEmail=1","url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/user-profiles/00570000001U0GXAA0/photo"},"reputation":{"reputationLevel":{"levelImageUrl":"/img/reputation/levelicons/reputation_level_05.png","levelName":"Dedicated","levelNumber":5},"reputationPoints":1386,"url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/users/00570000001U0GX/reputation"},"title":null,"type":"User","url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/users/00570000001U0GXAA0","userType":"Internal"}}],"nextPageToken":null,"nextPageUrl":null,"previousPageToken":null,"previousPageUrl":null,"total":1},"likesMessage":{"isRichText":null,"messageSegments":[{"motif":{"color":"1B96FF","largeIconUrl":"/img/icon/t4v35/standard/user_120.png","mediumIconUrl":"/img/icon/t4v35/standard/user_60.png","smallIconUrl":"/img/icon/t4v35/standard/user_60.png","svgIconUrl":"/img/icon/t4v35/standard/user.svg"},"reference":{"id":"00570000001U0GXAA0","url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/users/00570000001U0GXAA0"},"text":"Boris.Lekumovich","type":"EntityLink"},{"text":" likes this.","type":"Text"}],"text":"Boris.Lekumovich likes this."},"moderationFlags":{"flagCount":null,"flagCountByReason":{"FlaggedByRule":null,"FlaggedBySystem":null,"FlaggedByUserAsSpam":null,"FlaggedByUserAsInappropriate":null},"flaggedByMe":false,"flags":{"currentPageToken":null,"currentPageUrl":null,"flags":[],"nextPageToken":null,"nextPageUrl":null,"pageSize":null}},"myLike":null,"parent":{"id":"0054u000009LAOaAAO","url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/users/0054u000009LAOaAAO"},"relativeCreatedDate":"August 30, 2024 at 10:15 AM","threadLevel":0,"threadParentId":null,"type":"TextComment","url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/comments/0D7PO000002hutp0AA","user":{"additionalLabel":"Customer","communityNickname":"OverthinkerDave","companyName":null,"displayName":"OverthinkerDave","firstName":null,"id":"0054u000009M3d5AAC","isActive":true,"isInThisCommunity":true,"lastName":null,"motif":{"color":"1B96FF","largeIconUrl":"/img/icon/t4v35/standard/user_120.png","mediumIconUrl":"/img/icon/t4v35/standard/user_60.png","smallIconUrl":"/img/icon/t4v35/standard/user_60.png","svgIconUrl":"/img/icon/t4v35/standard/user.svg"},"mySubscription":null,"name":"OverthinkerDave","outOfOffice":{"message":""},"photo":{"fullEmailPhotoUrl":"https://community.securid.com/img/userprofile/default_profile_200_v2.png?fromEmail=1","largePhotoUrl":"https://community.securid.com/img/userprofile/default_profile_200_v2.png","mediumPhotoUrl":"https://community.securid.com/img/userprofile/default_profile_160_v2.png","photoVersionId":null,"smallPhotoUrl":"https://community.securid.com/img/userprofile/default_profile_45_v2.png","standardEmailPhotoUrl":"https://community.securid.com/img/userprofile/default_profile_45_v2.png?fromEmail=1","url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/user-profiles/0054u000009M3d5AAC/photo"},"reputation":{"reputationLevel":{"levelImageUrl":"/img/reputation/levelicons/reputation_level_03.png","levelName":"Intermediate","levelNumber":3},"reputationPoints":352,"url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/users/0054u000009M3d5/reputation"},"title":null,"type":"User","url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/users/0054u000009M3d5AAC","userType":"Portal"}},{"body":{"isRichText":false,"messageSegments":[{"text":"Thanks for the responses, I should have clarified better and will in the future. This is an ADC using SQL. Running this statement:\n\nSELECT DISTINCT up.AccountID as Account, up.AccountName as Name, up.AdminInd, up.RoleCnt, up.NetWorkMappingID as ID, up.SecGroup,ad.WFID, ad.isSupv, ad.Division,\n CASE\n WHEN up.AccountStatus = 'A' THEN 'Active'\n WHEN up.AccountStatus = 'I' THEN 'Inactive'\n WHEN up.AccountStatus = 'L' THEN 'Locked'\n WHEN up.AccountStatus = 'S' THEN 'Suspended'\n ELSE 'Unknown'\n END as AcctStatus,\n CASE\n WHEN ad.isSupv = 'N' THEN 'User'\n WHEN ad.isSupv = 'Y' THEN 'User'\n ELSE 'Orphan'\n END as AcctType,\n MID(up.LastLoginDate,1,10) + ' ' + MID(up.LastLoginDate,12,8) as LastLogin\nFROM UltiPro_Accounts up\nLEFT JOIN ags_sadusers ad ON LPAD(ad.WFID,9,'0') = LPAD(up.NetworkMappingID,9,'0')\n\n\nThe application passes through some old accounts that for one reason or another never logged in to this system as “0” in up.LastLoginDate. These come through successfully with the field blank but we receive an Admin Error:\nData Format Error in Account Record. Record ID=XUser, Attribute=LAST_LOGIN_DATE, Value=\"0 \", Expected Data Type=DATE Problem: Invalid Date Format or Date Range Acceptable Date Range From: 01-Jan-0001 00:00:00 To: 31-Dec-9999 23:59:59.\n\nI am looking for a manner in which to clean up this Admin Error if possible, alternatively I can replace the “0”s with a date of for instance 01-Jan-0001 00:00:00 if need be and it does quiet up which may be the best solution or to just ignore the Admin Error.","type":"Text"}],"text":"Thanks for the responses, I should have clarified better and will in the future. This is an ADC using SQL. Running this statement:\n\nSELECT DISTINCT up.AccountID as Account, up.AccountName as Name, up.AdminInd, up.RoleCnt, up.NetWorkMappingID as ID, up.SecGroup,ad.WFID, ad.isSupv, ad.Division,\n CASE\n WHEN up.AccountStatus = 'A' THEN 'Active'\n WHEN up.AccountStatus = 'I' THEN 'Inactive'\n WHEN up.AccountStatus = 'L' THEN 'Locked'\n WHEN up.AccountStatus = 'S' THEN 'Suspended'\n ELSE 'Unknown'\n END as AcctStatus,\n CASE\n WHEN ad.isSupv = 'N' THEN 'User'\n WHEN ad.isSupv = 'Y' THEN 'User'\n ELSE 'Orphan'\n END as AcctType,\n MID(up.LastLoginDate,1,10) + ' ' + MID(up.LastLoginDate,12,8) as LastLogin\nFROM UltiPro_Accounts up\nLEFT JOIN ags_sadusers ad ON LPAD(ad.WFID,9,'0') = LPAD(up.NetworkMappingID,9,'0')\n\n\nThe application passes through some old accounts that for one reason or another never logged in to this system as “0” in up.LastLoginDate. These come through successfully with the field blank but we receive an Admin Error:\nData Format Error in Account Record. Record ID=XUser, Attribute=LAST_LOGIN_DATE, Value=\"0 \", Expected Data Type=DATE Problem: Invalid Date Format or Date Range Acceptable Date Range From: 01-Jan-0001 00:00:00 To: 31-Dec-9999 23:59:59.\n\nI am looking for a manner in which to clean up this Admin Error if possible, alternatively I can replace the “0”s with a date of for instance 01-Jan-0001 00:00:00 if need be and it does quiet up which may be the best solution or to just ignore the Admin Error."},"capabilities":{"comments":{"page":{"currentPageToken":null,"currentPageUrl":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/comments/0D7PO000002i4I60AI/capabilities/comments/items","items":[],"nextPageToken":null,"nextPageUrl":null,"previousPageToken":null,"previousPageUrl":null,"total":1}},"edit":{"isEditRestricted":true,"isEditableByMeUrl":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/comments/0D7PO000002i4I60AI/capabilities/edit/is-editable-by-me","lastEditedBy":null,"lastEditedDate":null,"latestRevision":1,"relativeLastEditedDate":null},"status":{"feedEntityStatus":"Published","isApprovableByMe":false},"upDownVote":{"downVoteCount":0,"myVote":"None","upVoteCount":0},"verified":{"isVerifiableByMe":false,"isVerified":false,"isVerifiedByAnonymized":null,"lastVerifiedByUser":null,"lastVerifiedDate":null}},"clientInfo":null,"createdDate":"2024-08-30T14:40:49.000Z","feedElement":{"id":"0D5PO00000L2yAW0AZ","url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/feed-elements/0D5PO00000L2yAW0AZ"},"id":"0D7PO000002i4I60AI","isDeleteRestricted":true,"likes":{"currentPageToken":null,"currentPageUrl":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/comments/0D7PO000002i4I60AI/likes","items":[],"nextPageToken":null,"nextPageUrl":null,"previousPageToken":null,"previousPageUrl":null,"total":0},"likesMessage":null,"moderationFlags":{"flagCount":null,"flagCountByReason":{"FlaggedByRule":null,"FlaggedBySystem":null,"FlaggedByUserAsSpam":null,"FlaggedByUserAsInappropriate":null},"flaggedByMe":false,"flags":{"currentPageToken":null,"currentPageUrl":null,"flags":[],"nextPageToken":null,"nextPageUrl":null,"pageSize":null}},"myLike":null,"parent":{"id":"0054u000009LAOaAAO","url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/users/0054u000009LAOaAAO"},"relativeCreatedDate":"August 30, 2024 at 2:40 PM","threadLevel":1,"threadParentId":"0D7PO000002hutp0AA","type":"TextComment","url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/comments/0D7PO000002i4I60AI","user":{"additionalLabel":"Customer","communityNickname":"RobertYoung79390","companyName":null,"displayName":"RobertYoung79390","firstName":null,"id":"0054u000009LAOaAAO","isActive":true,"isInThisCommunity":true,"lastName":null,"motif":{"color":"1B96FF","largeIconUrl":"/img/icon/t4v35/standard/user_120.png","mediumIconUrl":"/img/icon/t4v35/standard/user_60.png","smallIconUrl":"/img/icon/t4v35/standard/user_60.png","svgIconUrl":"/img/icon/t4v35/standard/user.svg"},"mySubscription":null,"name":"RobertYoung79390","outOfOffice":{"message":""},"photo":{"fullEmailPhotoUrl":"https://community.securid.com/img/userprofile/default_profile_200_v2.png?fromEmail=1","largePhotoUrl":"https://community.securid.com/img/userprofile/default_profile_200_v2.png","mediumPhotoUrl":"https://community.securid.com/img/userprofile/default_profile_160_v2.png","photoVersionId":null,"smallPhotoUrl":"https://community.securid.com/img/userprofile/default_profile_45_v2.png","standardEmailPhotoUrl":"https://community.securid.com/img/userprofile/default_profile_45_v2.png?fromEmail=1","url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/user-profiles/0054u000009LAOaAAO/photo"},"reputation":{"reputationLevel":{"levelImageUrl":"/img/reputation/levelicons/reputation_level_01.png","levelName":"Beginner","levelNumber":1},"reputationPoints":18,"url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/users/0054u000009LAOa/reputation"},"title":null,"type":"User","url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/users/0054u000009LAOaAAO","userType":"Portal"}},{"body":{"isRichText":true,"messageSegments":[{"altText":null,"htmlTag":"p","markupType":"Paragraph","text":"","type":"MarkupBegin","url":null},{"text":"One approach you can consider is using case in your sql query.","type":"Text"},{"htmlTag":"p","markupType":"Paragraph","text":"\n","type":"MarkupEnd"},{"altText":null,"htmlTag":"p","markupType":"Paragraph","text":"","type":"MarkupBegin","url":null},{"text":" ","type":"Text"},{"htmlTag":"p","markupType":"Paragraph","text":"\n","type":"MarkupEnd"},{"altText":null,"htmlTag":"p","markupType":"Paragraph","text":"","type":"MarkupBegin","url":null},{"text":"for example:","type":"Text"},{"htmlTag":"p","markupType":"Paragraph","text":"\n","type":"MarkupEnd"},{"altText":null,"htmlTag":"p","markupType":"Paragraph","text":"","type":"MarkupBegin","url":null},{"text":"case ","type":"Text"},{"htmlTag":"p","markupType":"Paragraph","text":"\n","type":"MarkupEnd"},{"altText":null,"htmlTag":"p","markupType":"Paragraph","text":"","type":"MarkupBegin","url":null},{"text":"when up.LastLoginDate ='0' then Null","type":"Text"},{"htmlTag":"p","markupType":"Paragraph","text":"\n","type":"MarkupEnd"},{"altText":null,"htmlTag":"p","markupType":"Paragraph","text":"","type":"MarkupBegin","url":null},{"text":"else MID(up.LastLoginDate,1,10) + ' ' + MID(up.LastLoginDate,12,8)","type":"Text"},{"htmlTag":"p","markupType":"Paragraph","text":"\n","type":"MarkupEnd"},{"altText":null,"htmlTag":"p","markupType":"Paragraph","text":"","type":"MarkupBegin","url":null},{"text":"end as LastLogin","type":"Text"},{"htmlTag":"p","markupType":"Paragraph","text":"\n","type":"MarkupEnd"},{"altText":null,"htmlTag":"p","markupType":"Paragraph","text":"","type":"MarkupBegin","url":null},{"text":" ","type":"Text"},{"htmlTag":"p","markupType":"Paragraph","text":"\n","type":"MarkupEnd"},{"altText":null,"htmlTag":"p","markupType":"Paragraph","text":"","type":"MarkupBegin","url":null},{"text":"I haven't tested the query so you might need to adjust it a bit","type":"Text"},{"htmlTag":"p","markupType":"Paragraph","text":"\n","type":"MarkupEnd"}],"text":"One approach you can consider is using case in your sql query.\n \nfor example:\ncase \nwhen up.LastLoginDate ='0' then Null\nelse MID(up.LastLoginDate,1,10) + ' ' + MID(up.LastLoginDate,12,8)\nend as LastLogin\n \nI haven't tested the query so you might need to adjust it a bit\n"},"capabilities":{"comments":{"page":{"currentPageToken":null,"currentPageUrl":null,"items":[],"nextPageToken":null,"nextPageUrl":null,"previousPageToken":null,"previousPageUrl":null,"total":0}},"edit":{"isEditRestricted":true,"isEditableByMeUrl":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/comments/0D7PO000002imkX0AQ/capabilities/edit/is-editable-by-me","lastEditedBy":null,"lastEditedDate":null,"latestRevision":1,"relativeLastEditedDate":null},"status":{"feedEntityStatus":"Published","isApprovableByMe":false},"upDownVote":{"downVoteCount":0,"myVote":"None","upVoteCount":0},"verified":{"isVerifiableByMe":false,"isVerified":false,"isVerifiedByAnonymized":null,"lastVerifiedByUser":null,"lastVerifiedDate":null}},"clientInfo":null,"createdDate":"2024-09-02T00:13:17.000Z","feedElement":{"id":"0D5PO00000L2yAW0AZ","url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/feed-elements/0D5PO00000L2yAW0AZ"},"id":"0D7PO000002imkX0AQ","isDeleteRestricted":true,"likes":{"currentPageToken":null,"currentPageUrl":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/comments/0D7PO000002imkX0AQ/likes","items":[],"nextPageToken":null,"nextPageUrl":null,"previousPageToken":null,"previousPageUrl":null,"total":0},"likesMessage":null,"moderationFlags":{"flagCount":null,"flagCountByReason":{"FlaggedByRule":null,"FlaggedBySystem":null,"FlaggedByUserAsSpam":null,"FlaggedByUserAsInappropriate":null},"flaggedByMe":false,"flags":{"currentPageToken":null,"currentPageUrl":null,"flags":[],"nextPageToken":null,"nextPageUrl":null,"pageSize":null}},"myLike":null,"parent":{"id":"0054u000009LAOaAAO","url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/users/0054u000009LAOaAAO"},"relativeCreatedDate":"September 2, 2024 at 12:13 AM","threadLevel":2,"threadParentId":"0D7PO000002i4I60AI","type":"TextComment","url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/comments/0D7PO000002imkX0AQ","user":{"additionalLabel":"RSA","communityNickname":"Boris.Lekumovich","companyName":null,"displayName":"Boris.Lekumovich","firstName":null,"id":"00570000001U0GXAA0","isActive":true,"isInThisCommunity":true,"lastName":null,"motif":{"color":"1B96FF","largeIconUrl":"/img/icon/t4v35/standard/user_120.png","mediumIconUrl":"/img/icon/t4v35/standard/user_60.png","smallIconUrl":"/img/icon/t4v35/standard/user_60.png","svgIconUrl":"/img/icon/t4v35/standard/user.svg"},"mySubscription":null,"name":"Boris.Lekumovich","outOfOffice":{"message":""},"photo":{"fullEmailPhotoUrl":"https://community.securid.com/ncsphoto/UvsFQBOAp_JHaxfhtemq-vMXnkR4DpgkdNbmbAu9HK3IKnr98V_DEF7LQN-VrXJV?fromEmail=1","largePhotoUrl":"https://community.securid.com/ncsphoto/UvsFQBOAp_JHaxfhtemq-vMXnkR4DpgkdNbmbAu9HK3IKnr98V_DEF7LQN-VrXJV","mediumPhotoUrl":"https://community.securid.com/ncsphoto/UvsFQBOAp_JHaxfhtemq-vMXnkR4DpgkdNbmbAu9HK0OnK6vqB5VAzvNsyw-ACZY","photoVersionId":"729PO000002oq0fYAA","smallPhotoUrl":"https://community.securid.com/ncsphoto/UvsFQBOAp_JHaxfhtemq-vMXnkR4DpgkdNbmbAu9HK2BxIvkoyO75t0sir59ne4u","standardEmailPhotoUrl":"https://community.securid.com/ncsphoto/UvsFQBOAp_JHaxfhtemq-vMXnkR4DpgkdNbmbAu9HK2BxIvkoyO75t0sir59ne4u?fromEmail=1","url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/user-profiles/00570000001U0GXAA0/photo"},"reputation":{"reputationLevel":{"levelImageUrl":"/img/reputation/levelicons/reputation_level_05.png","levelName":"Dedicated","levelNumber":5},"reputationPoints":1386,"url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/users/00570000001U0GX/reputation"},"title":null,"type":"User","url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/users/00570000001U0GXAA0","userType":"Internal"}}],"nextPageToken":null,"nextPageUrl":null,"previousPageToken":null,"previousPageUrl":null,"total":4}},"edit":{"isEditRestricted":true,"isEditableByMeUrl":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/feed-elements/0D5PO00000L2yAW0AZ/capabilities/edit/is-editable-by-me","lastEditedBy":null,"lastEditedDate":null,"latestRevision":1,"relativeLastEditedDate":null},"interactions":{"count":82},"moderation":{"moderationFlags":{"flagCount":null,"flagCountByReason":{"FlaggedByRule":null,"FlaggedBySystem":null,"FlaggedByUserAsSpam":null,"FlaggedByUserAsInappropriate":null},"flaggedByMe":false,"flags":{"currentPageToken":null,"currentPageUrl":null,"flags":[],"nextPageToken":null,"nextPageUrl":null,"pageSize":null}}},"mute":{"isMutedByMe":null},"questionAndAnswers":{"bestAnswer":null,"bestAnswerSelectedBy":null,"canCurrentUserSelectOrRemoveBestAnswer":false,"candidateAnswers":null,"escalatedCase":null,"questionTitle":"Set Last Login Date to Null?"},"readBy":{"isReadByMe":true,"lastReadDateByMe":"2025-01-07T08:23:07.029Z","page":null},"status":{"feedEntityStatus":"Published","isApprovableByMe":false},"topics":{"canAssignTopics":true,"items":[{"createdDate":"2023-09-11T15:47:40.000Z","description":null,"id":"0TO4u0000017a3tGAA","images":{"coverImageUrl":null,"featuredImageUrl":null},"isBeingDeleted":false,"name":"RSA Governance & Lifecycle","nonLocalizedName":"RSA Governance & Lifecycle","talkingAbout":20,"url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/topics/0TO4u0000017a3tGAA"}]},"upDownVote":{"downVoteCount":0,"myVote":"None","upVoteCount":0}},"clientInfo":null,"createdDate":"2024-08-29T21:12:14.000Z","event":false,"feedElementType":"FeedItem","hasVerifiedComment":false,"header":{"isRichText":null,"messageSegments":[{"motif":{"color":"1B96FF","largeIconUrl":"/img/icon/t4v35/standard/user_120.png","mediumIconUrl":"/img/icon/t4v35/standard/user_60.png","smallIconUrl":"/img/icon/t4v35/standard/user_60.png","svgIconUrl":"/img/icon/t4v35/standard/user.svg"},"reference":{"id":"0054u000009LAOaAAO","url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/users/0054u000009LAOaAAO"},"text":"RobertYoung79390","type":"EntityLink"},{"text":" (Customer) asked a question.","type":"Text"}],"text":"RobertYoung79390 (Customer) asked a question."},"id":"0D5PO00000L2yAW0AZ","isDeleteRestricted":true,"isSharable":true,"modifiedDate":"2024-09-02T00:13:17.000Z","originalFeedItem":null,"originalFeedItemActor":null,"parent":{"additionalLabel":"Customer","communityNickname":"RobertYoung79390","companyName":null,"displayName":"RobertYoung79390","firstName":null,"id":"0054u000009LAOaAAO","isActive":true,"isInThisCommunity":true,"lastName":null,"motif":{"color":"1B96FF","largeIconUrl":"/img/icon/t4v35/standard/user_120.png","mediumIconUrl":"/img/icon/t4v35/standard/user_60.png","smallIconUrl":"/img/icon/t4v35/standard/user_60.png","svgIconUrl":"/img/icon/t4v35/standard/user.svg"},"mySubscription":null,"name":"RobertYoung79390","outOfOffice":{"message":""},"photo":{"fullEmailPhotoUrl":"https://community.securid.com/img/userprofile/default_profile_200_v2.png?fromEmail=1","largePhotoUrl":"https://community.securid.com/img/userprofile/default_profile_200_v2.png","mediumPhotoUrl":"https://community.securid.com/img/userprofile/default_profile_160_v2.png","photoVersionId":null,"smallPhotoUrl":"https://community.securid.com/img/userprofile/default_profile_45_v2.png","standardEmailPhotoUrl":"https://community.securid.com/img/userprofile/default_profile_45_v2.png?fromEmail=1","url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/user-profiles/0054u000009LAOaAAO/photo"},"reputation":{"reputationLevel":{"levelImageUrl":"/img/reputation/levelicons/reputation_level_01.png","levelName":"Beginner","levelNumber":1},"reputationPoints":18,"url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/users/0054u000009LAOa/reputation"},"title":null,"type":"User","url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/users/0054u000009LAOaAAO","userType":"Portal"},"photoUrl":"https://community.securid.com/img/userprofile/default_profile_45_v2.png","relativeCreatedDate":"August 29, 2024 at 9:12 PM","type":"QuestionPost","url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/feed-elements/0D5PO00000L2yAW0AZ?recentCommentCount=10&commentSort=CreatedDateOldestAsc","visibility":"AllUsers"},"commentActions":{"AttachFileFromSalesforce":{"executionComponent":{"descriptor":"markup://forceChatter:attachFileFromSalesforce","isEvent":true,"isClientSideCreatable":true,"componentName":"forceChatter:attachFileFromSalesforce","attributes":{}},"devNameOrId":"AttachFileFromSalesforce","isSelected":false,"requiresSelectionForUsage":false,"isSeparator":false,"reloadOnActivation":false,"isCachable":false,"label":"Select File","title":"Select File","icon":"https://community.securid.com/img/icon/t4v35/action/new_custom19_120.png","isRenderEntityIcon":true,"isDisabled":false,"isVisible":false,"assertive":false,"section":"SingleActionLinks","isMassAction":false,"isTargetRecordTypeIdPersonAccountType":false,"actionTypeEnum":"StandardButton"},"RemoveAllFlags":{"executionComponent":{"descriptor":"markup://forceChatter:flagAction","isEvent":false,"isClientSideCreatable":true,"componentName":"forceChatter:flagAction","attributes":{}},"devNameOrId":"RemoveAllFlags","isSelected":false,"requiresSelectionForUsage":false,"isSeparator":false,"reloadOnActivation":false,"isCachable":false,"label":"missing label Buttons.removeallflags","title":"missing label Buttons.removeallflags","icon":"https://community.securid.com/img/icon/t4v35/action/new_custom19_120.png","isRenderEntityIcon":true,"isDisabled":false,"isVisible":false,"assertive":false,"section":"SingleActionLinks","isMassAction":false,"isTargetRecordTypeIdPersonAccountType":false,"actionTypeEnum":"StandardButton"},"DeleteComment":{"beforeExecutionComponent":{"descriptor":"markup://force:confirmationWindow","isEvent":false,"isClientSideCreatable":true,"componentName":"force:confirmationWindow","attributes":{}},"executionComponent":{"descriptor":"markup://forceChatter:deleteCommentAction","isEvent":false,"isClientSideCreatable":true,"componentName":"forceChatter:deleteCommentAction","attributes":{}},"devNameOrId":"DeleteComment","isSelected":false,"requiresSelectionForUsage":false,"isSeparator":false,"reloadOnActivation":false,"isCachable":false,"label":"Delete","title":"Delete","icon":"https://community.securid.com/img/icon/t4v35/action/new_custom19_120.png","isRenderEntityIcon":true,"isDisabled":false,"isVisible":false,"assertive":false,"section":"SingleActionLinks","isMassAction":false,"isTargetRecordTypeIdPersonAccountType":false,"actionTypeEnum":"StandardButton"},"DownVote":{"executionComponent":{"descriptor":"markup://forceChatter:downVoteAction","isEvent":false,"isClientSideCreatable":true,"componentName":"forceChatter:downVoteAction","attributes":{}},"devNameOrId":"DownVote","isSelected":false,"requiresSelectionForUsage":false,"isSeparator":false,"reloadOnActivation":false,"isCachable":false,"label":"missing label Buttons.downvote","title":"missing label Buttons.downvote","icon":"https://community.securid.com/img/icon/t4v35/action/new_custom19_120.png","isRenderEntityIcon":true,"isDisabled":false,"isVisible":false,"assertive":false,"section":"SingleActionLinks","isMassAction":false,"isTargetRecordTypeIdPersonAccountType":false,"actionTypeEnum":"StandardButton"},"ApproveCommentItem":{"executionComponent":{"descriptor":"markup://forceChatter:changeFeedStatusAction","isEvent":false,"isClientSideCreatable":true,"componentName":"forceChatter:changeFeedStatusAction","attributes":{"isFeedItem":false}},"devNameOrId":"ApproveCommentItem","isSelected":false,"requiresSelectionForUsage":false,"isSeparator":false,"reloadOnActivation":false,"isCachable":false,"label":"Approve","title":"Approve","icon":"https://community.securid.com/img/icon/t4v35/action/new_custom19_120.png","isRenderEntityIcon":true,"isDisabled":false,"isVisible":false,"assertive":false,"section":"SingleActionLinks","isMassAction":false,"isTargetRecordTypeIdPersonAccountType":false,"actionTypeEnum":"StandardButton"},"EditComment":{"executionComponent":{"descriptor":"markup://forceChatter:editCommentAction","isEvent":false,"isClientSideCreatable":true,"componentName":"forceChatter:editCommentAction","attributes":{}},"devNameOrId":"EditComment","isSelected":false,"requiresSelectionForUsage":false,"isSeparator":false,"reloadOnActivation":false,"isCachable":false,"label":"Edit","title":"Edit","icon":"https://community.securid.com/img/icon/t4v35/action/new_custom19_120.png","isRenderEntityIcon":true,"isDisabled":false,"isVisible":false,"assertive":false,"section":"SingleActionLinks","isMassAction":false,"isTargetRecordTypeIdPersonAccountType":false,"actionTypeEnum":"StandardButton"},"Flag":{"executionComponent":{"descriptor":"markup://forceChatter:flagAction","isEvent":false,"isClientSideCreatable":true,"componentName":"forceChatter:flagAction","attributes":{}},"devNameOrId":"Flag","isSelected":false,"requiresSelectionForUsage":false,"isSeparator":false,"reloadOnActivation":false,"isCachable":false,"label":"missing label Buttons.flag","title":"missing label Buttons.flag","icon":"https://community.securid.com/img/icon/t4v35/action/new_custom19_120.png","isRenderEntityIcon":true,"isDisabled":false,"isVisible":false,"assertive":false,"section":"SingleActionLinks","isMassAction":false,"isTargetRecordTypeIdPersonAccountType":false,"actionTypeEnum":"StandardButton"},"VerifyUnverifyComment":{"executionComponent":{"descriptor":"markup://forceChatter:verifyUnverifyAction","isEvent":false,"isClientSideCreatable":true,"componentName":"forceChatter:verifyUnverifyAction","attributes":{}},"devNameOrId":"VerifyUnverifyComment","isSelected":false,"requiresSelectionForUsage":false,"isSeparator":false,"reloadOnActivation":false,"isCachable":false,"label":"Verify/Unverify Answer","title":"Verify/Unverify Answer","icon":"https://community.securid.com/img/icon/t4v35/action/new_custom19_120.png","isRenderEntityIcon":true,"isDisabled":false,"isVisible":false,"assertive":false,"section":"SingleActionLinks","isMassAction":false,"isTargetRecordTypeIdPersonAccountType":false,"actionTypeEnum":"StandardButton"}},"comments":{"currentPageToken":null,"currentPageUrl":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/feed-elements/0D5PO00000L2yAW0AZ/capabilities/comments/items?sort=CreatedDateOldestAsc","items":[{"body":{"isRichText":true,"messageSegments":[{"altText":null,"htmlTag":"p","markupType":"Paragraph","text":"","type":"MarkupBegin","url":null},{"text":"Hi Robert,","type":"Text"},{"htmlTag":"p","markupType":"Paragraph","text":"\n","type":"MarkupEnd"},{"altText":null,"htmlTag":"p","markupType":"Paragraph","text":"","type":"MarkupBegin","url":null},{"text":" ","type":"Text"},{"htmlTag":"p","markupType":"Paragraph","text":"\n","type":"MarkupEnd"},{"altText":null,"htmlTag":"p","markupType":"Paragraph","text":"","type":"MarkupBegin","url":null},{"text":"Can you clarify a bit more the situation? You are collecting a date attribute/value but you want it to presented as NULL in RSA GL? ","type":"Text"},{"htmlTag":"p","markupType":"Paragraph","text":"\n","type":"MarkupEnd"},{"altText":null,"htmlTag":"p","markupType":"Paragraph","text":"","type":"MarkupBegin","url":null},{"text":"What is the desired behavior?","type":"Text"},{"htmlTag":"p","markupType":"Paragraph","text":"\n","type":"MarkupEnd"},{"altText":null,"htmlTag":"p","markupType":"Paragraph","text":"","type":"MarkupBegin","url":null},{"text":"What type of collector you are using (JDBC/LDAP/API)?","type":"Text"},{"htmlTag":"p","markupType":"Paragraph","text":"\n","type":"MarkupEnd"},{"altText":null,"htmlTag":"p","markupType":"Paragraph","text":"","type":"MarkupBegin","url":null},{"text":"What version of RSA GL? ","type":"Text"},{"htmlTag":"p","markupType":"Paragraph","text":"\n","type":"MarkupEnd"},{"altText":null,"htmlTag":"p","markupType":"Paragraph","text":"","type":"MarkupBegin","url":null},{"text":" ","type":"Text"},{"htmlTag":"p","markupType":"Paragraph","text":"\n","type":"MarkupEnd"}],"text":"Hi Robert,\n \nCan you clarify a bit more the situation? You are collecting a date attribute/value but you want it to presented as NULL in RSA GL? \nWhat is the desired behavior?\nWhat type of collector you are using (JDBC/LDAP/API)?\nWhat version of RSA GL? \n \n"},"capabilities":{"comments":{"page":{"currentPageToken":null,"currentPageUrl":null,"items":[],"nextPageToken":null,"nextPageUrl":null,"previousPageToken":null,"previousPageUrl":null,"total":0}},"edit":{"isEditRestricted":true,"isEditableByMeUrl":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/comments/0D7PO000002hrkf0AA/capabilities/edit/is-editable-by-me","lastEditedBy":null,"lastEditedDate":null,"latestRevision":1,"relativeLastEditedDate":null},"status":{"feedEntityStatus":"Published","isApprovableByMe":false},"upDownVote":{"downVoteCount":0,"myVote":"None","upVoteCount":0},"verified":{"isVerifiableByMe":false,"isVerified":false,"isVerifiedByAnonymized":null,"lastVerifiedByUser":null,"lastVerifiedDate":null}},"clientInfo":null,"createdDate":"2024-08-30T00:17:00.000Z","feedElement":{"id":"0D5PO00000L2yAW0AZ","url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/feed-elements/0D5PO00000L2yAW0AZ"},"id":"0D7PO000002hrkf0AA","isDeleteRestricted":true,"likes":{"currentPageToken":null,"currentPageUrl":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/comments/0D7PO000002hrkf0AA/likes","items":[],"nextPageToken":null,"nextPageUrl":null,"previousPageToken":null,"previousPageUrl":null,"total":0},"likesMessage":null,"moderationFlags":{"flagCount":null,"flagCountByReason":{"FlaggedByRule":null,"FlaggedBySystem":null,"FlaggedByUserAsSpam":null,"FlaggedByUserAsInappropriate":null},"flaggedByMe":false,"flags":{"currentPageToken":null,"currentPageUrl":null,"flags":[],"nextPageToken":null,"nextPageUrl":null,"pageSize":null}},"myLike":null,"parent":{"id":"0054u000009LAOaAAO","url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/users/0054u000009LAOaAAO"},"relativeCreatedDate":"August 30, 2024 at 12:17 AM","threadLevel":0,"threadParentId":null,"type":"TextComment","url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/comments/0D7PO000002hrkf0AA","user":{"additionalLabel":"RSA","communityNickname":"Boris.Lekumovich","companyName":null,"displayName":"Boris.Lekumovich","firstName":null,"id":"00570000001U0GXAA0","isActive":true,"isInThisCommunity":true,"lastName":null,"motif":{"color":"1B96FF","largeIconUrl":"/img/icon/t4v35/standard/user_120.png","mediumIconUrl":"/img/icon/t4v35/standard/user_60.png","smallIconUrl":"/img/icon/t4v35/standard/user_60.png","svgIconUrl":"/img/icon/t4v35/standard/user.svg"},"mySubscription":null,"name":"Boris.Lekumovich","outOfOffice":{"message":""},"photo":{"fullEmailPhotoUrl":"https://community.securid.com/ncsphoto/UvsFQBOAp_JHaxfhtemq-vMXnkR4DpgkdNbmbAu9HK3IKnr98V_DEF7LQN-VrXJV?fromEmail=1","largePhotoUrl":"https://community.securid.com/ncsphoto/UvsFQBOAp_JHaxfhtemq-vMXnkR4DpgkdNbmbAu9HK3IKnr98V_DEF7LQN-VrXJV","mediumPhotoUrl":"https://community.securid.com/ncsphoto/UvsFQBOAp_JHaxfhtemq-vMXnkR4DpgkdNbmbAu9HK0OnK6vqB5VAzvNsyw-ACZY","photoVersionId":"729PO000002oq0fYAA","smallPhotoUrl":"https://community.securid.com/ncsphoto/UvsFQBOAp_JHaxfhtemq-vMXnkR4DpgkdNbmbAu9HK2BxIvkoyO75t0sir59ne4u","standardEmailPhotoUrl":"https://community.securid.com/ncsphoto/UvsFQBOAp_JHaxfhtemq-vMXnkR4DpgkdNbmbAu9HK2BxIvkoyO75t0sir59ne4u?fromEmail=1","url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/user-profiles/00570000001U0GXAA0/photo"},"reputation":{"reputationLevel":{"levelImageUrl":"/img/reputation/levelicons/reputation_level_05.png","levelName":"Dedicated","levelNumber":5},"reputationPoints":1386,"url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/users/00570000001U0GX/reputation"},"title":null,"type":"User","url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/users/00570000001U0GXAA0","userType":"Internal"}},{"body":{"isRichText":true,"messageSegments":[{"altText":null,"htmlTag":"p","markupType":"Paragraph","text":"","type":"MarkupBegin","url":null},{"text":"Title is confusing, because if you want null, and date is blank, you will get null (no matter which type it is)","type":"Text"},{"htmlTag":"p","markupType":"Paragraph","text":"\n","type":"MarkupEnd"},{"altText":null,"htmlTag":"p","markupType":"Paragraph","text":"","type":"MarkupBegin","url":null},{"text":" ","type":"Text"},{"htmlTag":"p","markupType":"Paragraph","text":"\n","type":"MarkupEnd"},{"altText":null,"htmlTag":"p","markupType":"Paragraph","text":"","type":"MarkupBegin","url":null},{"text":" ","type":"Text"},{"htmlTag":"p","markupType":"Paragraph","text":"\n","type":"MarkupEnd"},{"altText":null,"htmlTag":"p","markupType":"Paragraph","text":"","type":"MarkupBegin","url":null},{"text":"So doing an answer on the opposite: ","type":"Text"},{"altText":null,"htmlTag":"b","markupType":"Bold","text":"","type":"MarkupBegin","url":null},{"text":"I guess you want to collect Last Login Date?","type":"Text"},{"htmlTag":"b","markupType":"Bold","text":"","type":"MarkupEnd"},{"htmlTag":"p","markupType":"Paragraph","text":"\n","type":"MarkupEnd"},{"altText":null,"htmlTag":"p","markupType":"Paragraph","text":"","type":"MarkupBegin","url":null},{"text":"To be able to collect a Last Login Date, you need a collector that understands this \"as a date\".","type":"Text"},{"htmlTag":"p","markupType":"Paragraph","text":"\n","type":"MarkupEnd"},{"altText":null,"htmlTag":"p","markupType":"Paragraph","text":"","type":"MarkupBegin","url":null},{"text":" ","type":"Text"},{"htmlTag":"p","markupType":"Paragraph","text":"\n","type":"MarkupEnd"},{"altText":null,"htmlTag":"p","markupType":"Paragraph","text":"","type":"MarkupBegin","url":null},{"text":"LDAP-connectores (like the Windows one) are able to collect dates from AD, but there is no support for \"input transformation\". ","type":"Text"},{"htmlTag":"p","markupType":"Paragraph","text":"\n","type":"MarkupEnd"},{"altText":null,"htmlTag":"p","markupType":"Paragraph","text":"","type":"MarkupBegin","url":null},{"text":"This product only supports \"output transformation\" where an IDC synchronizes what has been read in. ","type":"Text"},{"htmlTag":"p","markupType":"Paragraph","text":"\n","type":"MarkupEnd"},{"altText":null,"htmlTag":"p","markupType":"Paragraph","text":"","type":"MarkupBegin","url":null},{"text":"But guessing you are talking about an ADC here, and then you need the Last Login Date field to be collected AS date (this due to it being used in reviews, to find accounts not logged in for a while)","type":"Text"},{"htmlTag":"p","markupType":"Paragraph","text":"\n","type":"MarkupEnd"},{"altText":null,"htmlTag":"p","markupType":"Paragraph","text":"","type":"MarkupBegin","url":null},{"text":" ","type":"Text"},{"htmlTag":"p","markupType":"Paragraph","text":"\n","type":"MarkupEnd"},{"altText":null,"htmlTag":"p","markupType":"Paragraph","text":"","type":"MarkupBegin","url":null},{"text":"So guessing here (you didn't give much info) I am guessing you have two paths:","type":"Text"},{"htmlTag":"p","markupType":"Paragraph","text":"\n","type":"MarkupEnd"},{"altText":null,"htmlTag":"ul","markupType":"UnorderedList","text":"","type":"MarkupBegin","url":null},{"altText":null,"htmlTag":"li","markupType":"ListItem","text":"- ","type":"MarkupBegin","url":null},{"text":"1) Find a way to make the (LDAP/REST) collector read the Last Login Date as date","type":"Text"},{"altText":null,"htmlTag":"ul","markupType":"UnorderedList","text":"","type":"MarkupBegin","url":null},{"altText":null,"htmlTag":"li","markupType":"ListItem","text":"- ","type":"MarkupBegin","url":null},{"text":"could be a entitlement issue. Maybe your application account don't have \"rights to read\" that attribute (often being an operational attribute)","type":"Text"},{"htmlTag":"li","markupType":"ListItem","text":"\n","type":"MarkupEnd"},{"htmlTag":"ul","markupType":"UnorderedList","text":"","type":"MarkupEnd"},{"htmlTag":"li","markupType":"ListItem","text":"\n","type":"MarkupEnd"},{"altText":null,"htmlTag":"li","markupType":"ListItem","text":"- ","type":"MarkupBegin","url":null},{"text":"2) Worst case: You need to use a SQL-based collector, which allows you to convert any of the incoming attributes to date.","type":"Text"},{"altText":null,"htmlTag":"ul","markupType":"UnorderedList","text":"","type":"MarkupBegin","url":null},{"altText":null,"htmlTag":"li","markupType":"ListItem","text":"- ","type":"MarkupBegin","url":null},{"text":"this scenario seems to need a product (an \"integration tool\") in between","type":"Text"},{"altText":null,"htmlTag":"ul","markupType":"UnorderedList","text":"","type":"MarkupBegin","url":null},{"altText":null,"htmlTag":"li","markupType":"ListItem","text":"- ","type":"MarkupBegin","url":null},{"text":"like ","type":"Text"},{"text":"teiid.io","type":"Link","url":"https://teiid.io"},{"text":" or ","type":"Text"},{"text":"tdi-users.org","type":"Link","url":"https://tdi-users.org"},{"htmlTag":"li","markupType":"ListItem","text":"\n","type":"MarkupEnd"},{"altText":null,"htmlTag":"li","markupType":"ListItem","text":"- ","type":"MarkupBegin","url":null},{"text":"these products then have the option to \"present true NULL\" to any system ","type":"Text"},{"altText":null,"htmlTag":"ul","markupType":"UnorderedList","text":"","type":"MarkupBegin","url":null},{"altText":null,"htmlTag":"li","markupType":"ListItem","text":"- ","type":"MarkupBegin","url":null},{"text":"although: for most collectors (LDAP/REST especially) \"empty string\" is treated same as NULL","type":"Text"},{"htmlTag":"li","markupType":"ListItem","text":"\n","type":"MarkupEnd"},{"htmlTag":"ul","markupType":"UnorderedList","text":"","type":"MarkupEnd"},{"htmlTag":"li","markupType":"ListItem","text":"\n","type":"MarkupEnd"},{"htmlTag":"ul","markupType":"UnorderedList","text":"","type":"MarkupEnd"},{"htmlTag":"li","markupType":"ListItem","text":"\n","type":"MarkupEnd"},{"altText":null,"htmlTag":"li","markupType":"ListItem","text":"- ","type":"MarkupBegin","url":null},{"text":"where this solution is more complicated, but give better solutions for say an LDAP-directory:","type":"Text"},{"altText":null,"htmlTag":"ul","markupType":"UnorderedList","text":"","type":"MarkupBegin","url":null},{"altText":null,"htmlTag":"li","markupType":"ListItem","text":"- ","type":"MarkupBegin","url":null},{"text":"In LDAP the \"last login\" is only created on that particular local server when the BIND happened","type":"Text"},{"htmlTag":"li","markupType":"ListItem","text":"\n","type":"MarkupEnd"},{"altText":null,"htmlTag":"li","markupType":"ListItem","text":"- ","type":"MarkupBegin","url":null},{"text":"Meaning: To get a \"real last login\" you need to collect all last logins from all servers in the cluster, and then present the \"newest\"","type":"Text"},{"altText":null,"htmlTag":"ul","markupType":"UnorderedList","text":"","type":"MarkupBegin","url":null},{"altText":null,"htmlTag":"li","markupType":"ListItem","text":"- ","type":"MarkupBegin","url":null},{"text":"this can only be done with more advanced data handlers like ","type":"Text"},{"text":"teiid.io","type":"Link","url":"https://teiid.io"},{"text":" or ","type":"Text"},{"text":"tdi-users.org","type":"Link","url":"https://tdi-users.org"},{"htmlTag":"li","markupType":"ListItem","text":"\n","type":"MarkupEnd"},{"htmlTag":"ul","markupType":"UnorderedList","text":"","type":"MarkupEnd"},{"htmlTag":"li","markupType":"ListItem","text":"\n","type":"MarkupEnd"},{"htmlTag":"ul","markupType":"UnorderedList","text":"","type":"MarkupEnd"},{"htmlTag":"li","markupType":"ListItem","text":"\n","type":"MarkupEnd"},{"htmlTag":"ul","markupType":"UnorderedList","text":"","type":"MarkupEnd"},{"htmlTag":"li","markupType":"ListItem","text":"\n","type":"MarkupEnd"},{"htmlTag":"ul","markupType":"UnorderedList","text":"","type":"MarkupEnd"},{"altText":null,"htmlTag":"p","markupType":"Paragraph","text":"","type":"MarkupBegin","url":null},{"text":" ","type":"Text"},{"htmlTag":"p","markupType":"Paragraph","text":"\n","type":"MarkupEnd"},{"altText":null,"htmlTag":"p","markupType":"Paragraph","text":"","type":"MarkupBegin","url":null},{"text":"In summary NULL-problems are always complicated, and will stop talking now. But there are 7 different places in the product which treats NULL differently.","type":"Text"},{"htmlTag":"p","markupType":"Paragraph","text":"\n","type":"MarkupEnd"}],"text":"Title is confusing, because if you want null, and date is blank, you will get null (no matter which type it is)\n \n \nSo doing an answer on the opposite: I guess you want to collect Last Login Date?\nTo be able to collect a Last Login Date, you need a collector that understands this \"as a date\".\n \nLDAP-connectores (like the Windows one) are able to collect dates from AD, but there is no support for \"input transformation\". \nThis product only supports \"output transformation\" where an IDC synchronizes what has been read in. \nBut guessing you are talking about an ADC here, and then you need the Last Login Date field to be collected AS date (this due to it being used in reviews, to find accounts not logged in for a while)\n \nSo guessing here (you didn't give much info) I am guessing you have two paths:\n- 1) Find a way to make the (LDAP/REST) collector read the Last Login Date as date- could be a entitlement issue. Maybe your application account don't have \"rights to read\" that attribute (often being an operational attribute)\n\n- 2) Worst case: You need to use a SQL-based collector, which allows you to convert any of the incoming attributes to date.- this scenario seems to need a product (an \"integration tool\") in between- like teiid.io or tdi-users.org\n- these products then have the option to \"present true NULL\" to any system - although: for most collectors (LDAP/REST especially) \"empty string\" is treated same as NULL\n\n\n- where this solution is more complicated, but give better solutions for say an LDAP-directory:- In LDAP the \"last login\" is only created on that particular local server when the BIND happened\n- Meaning: To get a \"real last login\" you need to collect all last logins from all servers in the cluster, and then present the \"newest\"- this can only be done with more advanced data handlers like teiid.io or tdi-users.org\n\n\n\n \nIn summary NULL-problems are always complicated, and will stop talking now. But there are 7 different places in the product which treats NULL differently.\n"},"capabilities":{"comments":{"page":{"currentPageToken":null,"currentPageUrl":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/comments/0D7PO000002hutp0AA/capabilities/comments/items","items":[],"nextPageToken":null,"nextPageUrl":null,"previousPageToken":null,"previousPageUrl":null,"total":1}},"edit":{"isEditRestricted":true,"isEditableByMeUrl":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/comments/0D7PO000002hutp0AA/capabilities/edit/is-editable-by-me","lastEditedBy":null,"lastEditedDate":null,"latestRevision":1,"relativeLastEditedDate":null},"status":{"feedEntityStatus":"Published","isApprovableByMe":false},"upDownVote":{"downVoteCount":0,"myVote":"None","upVoteCount":1},"verified":{"isVerifiableByMe":false,"isVerified":false,"isVerifiedByAnonymized":null,"lastVerifiedByUser":null,"lastVerifiedDate":null}},"clientInfo":null,"createdDate":"2024-08-30T10:15:31.000Z","feedElement":{"id":"0D5PO00000L2yAW0AZ","url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/feed-elements/0D5PO00000L2yAW0AZ"},"id":"0D7PO000002hutp0AA","isDeleteRestricted":true,"likes":{"currentPageToken":0,"currentPageUrl":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/comments/0D7PO000002hutp0AA/likes","items":[{"id":"0I0PO000000sJs50AE","likedItem":{"id":"0D7PO000002hutp0AA","url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/comments/0D7PO000002hutp0AA"},"url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/likes/0I0PO000000sJs50AE","user":{"additionalLabel":"RSA","communityNickname":"Boris.Lekumovich","companyName":null,"displayName":"Boris.Lekumovich","firstName":null,"id":"00570000001U0GXAA0","isActive":true,"isInThisCommunity":true,"lastName":null,"motif":{"color":"1B96FF","largeIconUrl":"/img/icon/t4v35/standard/user_120.png","mediumIconUrl":"/img/icon/t4v35/standard/user_60.png","smallIconUrl":"/img/icon/t4v35/standard/user_60.png","svgIconUrl":"/img/icon/t4v35/standard/user.svg"},"mySubscription":null,"name":"Boris.Lekumovich","outOfOffice":{"message":""},"photo":{"fullEmailPhotoUrl":"https://community.securid.com/ncsphoto/UvsFQBOAp_JHaxfhtemq-vMXnkR4DpgkdNbmbAu9HK3IKnr98V_DEF7LQN-VrXJV?fromEmail=1","largePhotoUrl":"https://community.securid.com/ncsphoto/UvsFQBOAp_JHaxfhtemq-vMXnkR4DpgkdNbmbAu9HK3IKnr98V_DEF7LQN-VrXJV","mediumPhotoUrl":"https://community.securid.com/ncsphoto/UvsFQBOAp_JHaxfhtemq-vMXnkR4DpgkdNbmbAu9HK0OnK6vqB5VAzvNsyw-ACZY","photoVersionId":"729PO000002oq0fYAA","smallPhotoUrl":"https://community.securid.com/ncsphoto/UvsFQBOAp_JHaxfhtemq-vMXnkR4DpgkdNbmbAu9HK2BxIvkoyO75t0sir59ne4u","standardEmailPhotoUrl":"https://community.securid.com/ncsphoto/UvsFQBOAp_JHaxfhtemq-vMXnkR4DpgkdNbmbAu9HK2BxIvkoyO75t0sir59ne4u?fromEmail=1","url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/user-profiles/00570000001U0GXAA0/photo"},"reputation":{"reputationLevel":{"levelImageUrl":"/img/reputation/levelicons/reputation_level_05.png","levelName":"Dedicated","levelNumber":5},"reputationPoints":1386,"url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/users/00570000001U0GX/reputation"},"title":null,"type":"User","url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/users/00570000001U0GXAA0","userType":"Internal"}}],"nextPageToken":null,"nextPageUrl":null,"previousPageToken":null,"previousPageUrl":null,"total":1},"likesMessage":{"isRichText":null,"messageSegments":[{"motif":{"color":"1B96FF","largeIconUrl":"/img/icon/t4v35/standard/user_120.png","mediumIconUrl":"/img/icon/t4v35/standard/user_60.png","smallIconUrl":"/img/icon/t4v35/standard/user_60.png","svgIconUrl":"/img/icon/t4v35/standard/user.svg"},"reference":{"id":"00570000001U0GXAA0","url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/users/00570000001U0GXAA0"},"text":"Boris.Lekumovich","type":"EntityLink"},{"text":" likes this.","type":"Text"}],"text":"Boris.Lekumovich likes this."},"moderationFlags":{"flagCount":null,"flagCountByReason":{"FlaggedByRule":null,"FlaggedBySystem":null,"FlaggedByUserAsSpam":null,"FlaggedByUserAsInappropriate":null},"flaggedByMe":false,"flags":{"currentPageToken":null,"currentPageUrl":null,"flags":[],"nextPageToken":null,"nextPageUrl":null,"pageSize":null}},"myLike":null,"parent":{"id":"0054u000009LAOaAAO","url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/users/0054u000009LAOaAAO"},"relativeCreatedDate":"August 30, 2024 at 10:15 AM","threadLevel":0,"threadParentId":null,"type":"TextComment","url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/comments/0D7PO000002hutp0AA","user":{"additionalLabel":"Customer","communityNickname":"OverthinkerDave","companyName":null,"displayName":"OverthinkerDave","firstName":null,"id":"0054u000009M3d5AAC","isActive":true,"isInThisCommunity":true,"lastName":null,"motif":{"color":"1B96FF","largeIconUrl":"/img/icon/t4v35/standard/user_120.png","mediumIconUrl":"/img/icon/t4v35/standard/user_60.png","smallIconUrl":"/img/icon/t4v35/standard/user_60.png","svgIconUrl":"/img/icon/t4v35/standard/user.svg"},"mySubscription":null,"name":"OverthinkerDave","outOfOffice":{"message":""},"photo":{"fullEmailPhotoUrl":"https://community.securid.com/img/userprofile/default_profile_200_v2.png?fromEmail=1","largePhotoUrl":"https://community.securid.com/img/userprofile/default_profile_200_v2.png","mediumPhotoUrl":"https://community.securid.com/img/userprofile/default_profile_160_v2.png","photoVersionId":null,"smallPhotoUrl":"https://community.securid.com/img/userprofile/default_profile_45_v2.png","standardEmailPhotoUrl":"https://community.securid.com/img/userprofile/default_profile_45_v2.png?fromEmail=1","url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/user-profiles/0054u000009M3d5AAC/photo"},"reputation":{"reputationLevel":{"levelImageUrl":"/img/reputation/levelicons/reputation_level_03.png","levelName":"Intermediate","levelNumber":3},"reputationPoints":352,"url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/users/0054u000009M3d5/reputation"},"title":null,"type":"User","url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/users/0054u000009M3d5AAC","userType":"Portal"}},{"body":{"isRichText":false,"messageSegments":[{"text":"Thanks for the responses, I should have clarified better and will in the future. This is an ADC using SQL. Running this statement:\n\nSELECT DISTINCT up.AccountID as Account, up.AccountName as Name, up.AdminInd, up.RoleCnt, up.NetWorkMappingID as ID, up.SecGroup,ad.WFID, ad.isSupv, ad.Division,\n CASE\n WHEN up.AccountStatus = 'A' THEN 'Active'\n WHEN up.AccountStatus = 'I' THEN 'Inactive'\n WHEN up.AccountStatus = 'L' THEN 'Locked'\n WHEN up.AccountStatus = 'S' THEN 'Suspended'\n ELSE 'Unknown'\n END as AcctStatus,\n CASE\n WHEN ad.isSupv = 'N' THEN 'User'\n WHEN ad.isSupv = 'Y' THEN 'User'\n ELSE 'Orphan'\n END as AcctType,\n MID(up.LastLoginDate,1,10) + ' ' + MID(up.LastLoginDate,12,8) as LastLogin\nFROM UltiPro_Accounts up\nLEFT JOIN ags_sadusers ad ON LPAD(ad.WFID,9,'0') = LPAD(up.NetworkMappingID,9,'0')\n\n\nThe application passes through some old accounts that for one reason or another never logged in to this system as “0” in up.LastLoginDate. These come through successfully with the field blank but we receive an Admin Error:\nData Format Error in Account Record. Record ID=XUser, Attribute=LAST_LOGIN_DATE, Value=\"0 \", Expected Data Type=DATE Problem: Invalid Date Format or Date Range Acceptable Date Range From: 01-Jan-0001 00:00:00 To: 31-Dec-9999 23:59:59.\n\nI am looking for a manner in which to clean up this Admin Error if possible, alternatively I can replace the “0”s with a date of for instance 01-Jan-0001 00:00:00 if need be and it does quiet up which may be the best solution or to just ignore the Admin Error.","type":"Text"}],"text":"Thanks for the responses, I should have clarified better and will in the future. This is an ADC using SQL. Running this statement:\n\nSELECT DISTINCT up.AccountID as Account, up.AccountName as Name, up.AdminInd, up.RoleCnt, up.NetWorkMappingID as ID, up.SecGroup,ad.WFID, ad.isSupv, ad.Division,\n CASE\n WHEN up.AccountStatus = 'A' THEN 'Active'\n WHEN up.AccountStatus = 'I' THEN 'Inactive'\n WHEN up.AccountStatus = 'L' THEN 'Locked'\n WHEN up.AccountStatus = 'S' THEN 'Suspended'\n ELSE 'Unknown'\n END as AcctStatus,\n CASE\n WHEN ad.isSupv = 'N' THEN 'User'\n WHEN ad.isSupv = 'Y' THEN 'User'\n ELSE 'Orphan'\n END as AcctType,\n MID(up.LastLoginDate,1,10) + ' ' + MID(up.LastLoginDate,12,8) as LastLogin\nFROM UltiPro_Accounts up\nLEFT JOIN ags_sadusers ad ON LPAD(ad.WFID,9,'0') = LPAD(up.NetworkMappingID,9,'0')\n\n\nThe application passes through some old accounts that for one reason or another never logged in to this system as “0” in up.LastLoginDate. These come through successfully with the field blank but we receive an Admin Error:\nData Format Error in Account Record. Record ID=XUser, Attribute=LAST_LOGIN_DATE, Value=\"0 \", Expected Data Type=DATE Problem: Invalid Date Format or Date Range Acceptable Date Range From: 01-Jan-0001 00:00:00 To: 31-Dec-9999 23:59:59.\n\nI am looking for a manner in which to clean up this Admin Error if possible, alternatively I can replace the “0”s with a date of for instance 01-Jan-0001 00:00:00 if need be and it does quiet up which may be the best solution or to just ignore the Admin Error."},"capabilities":{"comments":{"page":{"currentPageToken":null,"currentPageUrl":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/comments/0D7PO000002i4I60AI/capabilities/comments/items","items":[],"nextPageToken":null,"nextPageUrl":null,"previousPageToken":null,"previousPageUrl":null,"total":1}},"edit":{"isEditRestricted":true,"isEditableByMeUrl":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/comments/0D7PO000002i4I60AI/capabilities/edit/is-editable-by-me","lastEditedBy":null,"lastEditedDate":null,"latestRevision":1,"relativeLastEditedDate":null},"status":{"feedEntityStatus":"Published","isApprovableByMe":false},"upDownVote":{"downVoteCount":0,"myVote":"None","upVoteCount":0},"verified":{"isVerifiableByMe":false,"isVerified":false,"isVerifiedByAnonymized":null,"lastVerifiedByUser":null,"lastVerifiedDate":null}},"clientInfo":null,"createdDate":"2024-08-30T14:40:49.000Z","feedElement":{"id":"0D5PO00000L2yAW0AZ","url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/feed-elements/0D5PO00000L2yAW0AZ"},"id":"0D7PO000002i4I60AI","isDeleteRestricted":true,"likes":{"currentPageToken":null,"currentPageUrl":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/comments/0D7PO000002i4I60AI/likes","items":[],"nextPageToken":null,"nextPageUrl":null,"previousPageToken":null,"previousPageUrl":null,"total":0},"likesMessage":null,"moderationFlags":{"flagCount":null,"flagCountByReason":{"FlaggedByRule":null,"FlaggedBySystem":null,"FlaggedByUserAsSpam":null,"FlaggedByUserAsInappropriate":null},"flaggedByMe":false,"flags":{"currentPageToken":null,"currentPageUrl":null,"flags":[],"nextPageToken":null,"nextPageUrl":null,"pageSize":null}},"myLike":null,"parent":{"id":"0054u000009LAOaAAO","url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/users/0054u000009LAOaAAO"},"relativeCreatedDate":"August 30, 2024 at 2:40 PM","threadLevel":1,"threadParentId":"0D7PO000002hutp0AA","type":"TextComment","url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/comments/0D7PO000002i4I60AI","user":{"additionalLabel":"Customer","communityNickname":"RobertYoung79390","companyName":null,"displayName":"RobertYoung79390","firstName":null,"id":"0054u000009LAOaAAO","isActive":true,"isInThisCommunity":true,"lastName":null,"motif":{"color":"1B96FF","largeIconUrl":"/img/icon/t4v35/standard/user_120.png","mediumIconUrl":"/img/icon/t4v35/standard/user_60.png","smallIconUrl":"/img/icon/t4v35/standard/user_60.png","svgIconUrl":"/img/icon/t4v35/standard/user.svg"},"mySubscription":null,"name":"RobertYoung79390","outOfOffice":{"message":""},"photo":{"fullEmailPhotoUrl":"https://community.securid.com/img/userprofile/default_profile_200_v2.png?fromEmail=1","largePhotoUrl":"https://community.securid.com/img/userprofile/default_profile_200_v2.png","mediumPhotoUrl":"https://community.securid.com/img/userprofile/default_profile_160_v2.png","photoVersionId":null,"smallPhotoUrl":"https://community.securid.com/img/userprofile/default_profile_45_v2.png","standardEmailPhotoUrl":"https://community.securid.com/img/userprofile/default_profile_45_v2.png?fromEmail=1","url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/user-profiles/0054u000009LAOaAAO/photo"},"reputation":{"reputationLevel":{"levelImageUrl":"/img/reputation/levelicons/reputation_level_01.png","levelName":"Beginner","levelNumber":1},"reputationPoints":18,"url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/users/0054u000009LAOa/reputation"},"title":null,"type":"User","url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/users/0054u000009LAOaAAO","userType":"Portal"}},{"body":{"isRichText":true,"messageSegments":[{"altText":null,"htmlTag":"p","markupType":"Paragraph","text":"","type":"MarkupBegin","url":null},{"text":"One approach you can consider is using case in your sql query.","type":"Text"},{"htmlTag":"p","markupType":"Paragraph","text":"\n","type":"MarkupEnd"},{"altText":null,"htmlTag":"p","markupType":"Paragraph","text":"","type":"MarkupBegin","url":null},{"text":" ","type":"Text"},{"htmlTag":"p","markupType":"Paragraph","text":"\n","type":"MarkupEnd"},{"altText":null,"htmlTag":"p","markupType":"Paragraph","text":"","type":"MarkupBegin","url":null},{"text":"for example:","type":"Text"},{"htmlTag":"p","markupType":"Paragraph","text":"\n","type":"MarkupEnd"},{"altText":null,"htmlTag":"p","markupType":"Paragraph","text":"","type":"MarkupBegin","url":null},{"text":"case ","type":"Text"},{"htmlTag":"p","markupType":"Paragraph","text":"\n","type":"MarkupEnd"},{"altText":null,"htmlTag":"p","markupType":"Paragraph","text":"","type":"MarkupBegin","url":null},{"text":"when up.LastLoginDate ='0' then Null","type":"Text"},{"htmlTag":"p","markupType":"Paragraph","text":"\n","type":"MarkupEnd"},{"altText":null,"htmlTag":"p","markupType":"Paragraph","text":"","type":"MarkupBegin","url":null},{"text":"else MID(up.LastLoginDate,1,10) + ' ' + MID(up.LastLoginDate,12,8)","type":"Text"},{"htmlTag":"p","markupType":"Paragraph","text":"\n","type":"MarkupEnd"},{"altText":null,"htmlTag":"p","markupType":"Paragraph","text":"","type":"MarkupBegin","url":null},{"text":"end as LastLogin","type":"Text"},{"htmlTag":"p","markupType":"Paragraph","text":"\n","type":"MarkupEnd"},{"altText":null,"htmlTag":"p","markupType":"Paragraph","text":"","type":"MarkupBegin","url":null},{"text":" ","type":"Text"},{"htmlTag":"p","markupType":"Paragraph","text":"\n","type":"MarkupEnd"},{"altText":null,"htmlTag":"p","markupType":"Paragraph","text":"","type":"MarkupBegin","url":null},{"text":"I haven't tested the query so you might need to adjust it a bit","type":"Text"},{"htmlTag":"p","markupType":"Paragraph","text":"\n","type":"MarkupEnd"}],"text":"One approach you can consider is using case in your sql query.\n \nfor example:\ncase \nwhen up.LastLoginDate ='0' then Null\nelse MID(up.LastLoginDate,1,10) + ' ' + MID(up.LastLoginDate,12,8)\nend as LastLogin\n \nI haven't tested the query so you might need to adjust it a bit\n"},"capabilities":{"comments":{"page":{"currentPageToken":null,"currentPageUrl":null,"items":[],"nextPageToken":null,"nextPageUrl":null,"previousPageToken":null,"previousPageUrl":null,"total":0}},"edit":{"isEditRestricted":true,"isEditableByMeUrl":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/comments/0D7PO000002imkX0AQ/capabilities/edit/is-editable-by-me","lastEditedBy":null,"lastEditedDate":null,"latestRevision":1,"relativeLastEditedDate":null},"status":{"feedEntityStatus":"Published","isApprovableByMe":false},"upDownVote":{"downVoteCount":0,"myVote":"None","upVoteCount":0},"verified":{"isVerifiableByMe":false,"isVerified":false,"isVerifiedByAnonymized":null,"lastVerifiedByUser":null,"lastVerifiedDate":null}},"clientInfo":null,"createdDate":"2024-09-02T00:13:17.000Z","feedElement":{"id":"0D5PO00000L2yAW0AZ","url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/feed-elements/0D5PO00000L2yAW0AZ"},"id":"0D7PO000002imkX0AQ","isDeleteRestricted":true,"likes":{"currentPageToken":null,"currentPageUrl":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/comments/0D7PO000002imkX0AQ/likes","items":[],"nextPageToken":null,"nextPageUrl":null,"previousPageToken":null,"previousPageUrl":null,"total":0},"likesMessage":null,"moderationFlags":{"flagCount":null,"flagCountByReason":{"FlaggedByRule":null,"FlaggedBySystem":null,"FlaggedByUserAsSpam":null,"FlaggedByUserAsInappropriate":null},"flaggedByMe":false,"flags":{"currentPageToken":null,"currentPageUrl":null,"flags":[],"nextPageToken":null,"nextPageUrl":null,"pageSize":null}},"myLike":null,"parent":{"id":"0054u000009LAOaAAO","url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/users/0054u000009LAOaAAO"},"relativeCreatedDate":"September 2, 2024 at 12:13 AM","threadLevel":2,"threadParentId":"0D7PO000002i4I60AI","type":"TextComment","url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/comments/0D7PO000002imkX0AQ","user":{"additionalLabel":"RSA","communityNickname":"Boris.Lekumovich","companyName":null,"displayName":"Boris.Lekumovich","firstName":null,"id":"00570000001U0GXAA0","isActive":true,"isInThisCommunity":true,"lastName":null,"motif":{"color":"1B96FF","largeIconUrl":"/img/icon/t4v35/standard/user_120.png","mediumIconUrl":"/img/icon/t4v35/standard/user_60.png","smallIconUrl":"/img/icon/t4v35/standard/user_60.png","svgIconUrl":"/img/icon/t4v35/standard/user.svg"},"mySubscription":null,"name":"Boris.Lekumovich","outOfOffice":{"message":""},"photo":{"fullEmailPhotoUrl":"https://community.securid.com/ncsphoto/UvsFQBOAp_JHaxfhtemq-vMXnkR4DpgkdNbmbAu9HK3IKnr98V_DEF7LQN-VrXJV?fromEmail=1","largePhotoUrl":"https://community.securid.com/ncsphoto/UvsFQBOAp_JHaxfhtemq-vMXnkR4DpgkdNbmbAu9HK3IKnr98V_DEF7LQN-VrXJV","mediumPhotoUrl":"https://community.securid.com/ncsphoto/UvsFQBOAp_JHaxfhtemq-vMXnkR4DpgkdNbmbAu9HK0OnK6vqB5VAzvNsyw-ACZY","photoVersionId":"729PO000002oq0fYAA","smallPhotoUrl":"https://community.securid.com/ncsphoto/UvsFQBOAp_JHaxfhtemq-vMXnkR4DpgkdNbmbAu9HK2BxIvkoyO75t0sir59ne4u","standardEmailPhotoUrl":"https://community.securid.com/ncsphoto/UvsFQBOAp_JHaxfhtemq-vMXnkR4DpgkdNbmbAu9HK2BxIvkoyO75t0sir59ne4u?fromEmail=1","url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/user-profiles/00570000001U0GXAA0/photo"},"reputation":{"reputationLevel":{"levelImageUrl":"/img/reputation/levelicons/reputation_level_05.png","levelName":"Dedicated","levelNumber":5},"reputationPoints":1386,"url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/users/00570000001U0GX/reputation"},"title":null,"type":"User","url":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/users/00570000001U0GXAA0","userType":"Internal"}}],"nextPageToken":null,"nextPageUrl":null,"previousPageToken":null,"previousPageUrl":null,"total":4},"topRankedComments":{"currentPageToken":null,"currentPageUrl":"/services/data/v62.0/connect/communities/0DB4u000000sYYPGA2/chatter/feed-elements/0D5PO00000L2yAW0AZ/capabilities/comments/items?sort=Relevance","items":[],"nextPageToken":null,"nextPageUrl":null,"previousPageToken":null,"previousPageUrl":null,"total":4},"feedConfig":{"subjectId":"0054u000009LAOaAAO","communityId":{"rawValue":"0DB4u000000sYYP","communityId":{"value":"0DB4u000000sYYP"},"isAll":false,"isInternal":false,"isActive":true},"isPrivateGroup":false,"density":"AllUpdates","isTopicsEnabled":true,"isThreadedEnabled":true,"commentSortOrder":"CreatedDateOldestAsc","threadedConversationLevelLimit":3,"feedDisplayConfig":{"feedElementDisplayConfig":{"bodyTruncation":"NONE","auxBodyDetail":"FULL","topicsDetail":"SIMPLE","bodyTruncationLimit":400,"showInlineComments":true,"useLargeDrillInTarget":false,"showLikesDetail":true,"showLikeAction":true,"showOverflowActionsMenu":true,"showBookmarkStatus":true,"showBookmarkAction":true,"showDeleteAction":true,"showModerationAction":true,"truncateAttachments":false,"mode":"DRILL_IN","feedUiDesign":"BROWSE"},"commentsDisplayConfig":{"commentInputStyle":"INLINE","pagingMode":"PULL","postActionsDisplay":"ALWAYS","commentBodyTruncationLimit":400,"firstPageSize":10,"nextPageSize":20,"searchResultsCount":0,"showLikeAction":true,"showLikes":true,"showDeleteAction":true,"showModerationAction":true,"mode":"DRILL_IN","feedUiDesign":"BROWSE"},"actionLinksDisplayConfig":{"platformActionsStatus":"PRIMARY","showPrimaryActionLink":true,"showUnclassifiedPlatformActions":true,"mode":"DRILL_IN","feedUiDesign":"BROWSE"},"contextUser":{"id":"0054u0000092v3qAAA","userType":"Guest","photo":{"smallPhotoUrl":"https://community.securid.com/img/userprofile/default_profile_45_v2.png"},"displayName":"RSA_Community"},"firstPageSize":8,"nextPageSize":8,"searching":false,"mode":"DRILL_IN","feedUiDesign":"BROWSE"},"feedItemType":"QuestionPost","isRealtimeEnabled":true,"isRealtimeDiagnosticsEnabled":false,"isFeedUIExperimentsEnabled":false,"isFeedReadTrackingEnabled":false,"streamingApiSessionKey":"a7ffc6f8bf1ed76651c14756a061d662f580ff4de43b49fa82d80a4b80f8434a","cometdUrl":"","richTextConfig":{"isRichTextEnabled":true,"isQuillEditorEnabled":true,"isCodeSnippetUserPermEnabled":false,"isEmojiPermEnabled":true,"isRichTextMobileEnabled":true,"isEntityLinksEnabledInLex":true,"isEntityLinksEnabledInCommunities":false,"isDraftPostsEnabled":false,"isDraftPostsAutosaveEnabled":false,"isCommentExtensionsEnabled":false},"isCompanyRelevanceFeedEnabled":false,"isDirectMessagesEnabled":true,"isUpDownVoteEnabled":false,"retrieveOnlyTopLevelThreadedComments":false,"canUserDeleteComment":true,"isTranslationEnabled":true,"canUserMovePosts":false,"isCaseFeedReadUnreadEnabled":false,"isCaseFeedLWCEnabled":false,"isCaseFeedRelativeTimestampsEnabled":false},"isChatterEnabled":true,"contextUser":{"id":"0054u0000092v3qAAA","userType":"Guest","photo":{"smallPhotoUrl":"https://community.securid.com/img/userprofile/default_profile_45_v2.png"},"displayName":"RSA_Community"}},"error":[]}
Failing descriptor: {forceChatter:feedElementFullView}