AnsweredAssumed Answered

NSQL Resource Users

Question asked by christianesler1319552 on May 11, 2012
Latest reply on May 12, 2012 by Dave
Hello,

I am missing something - I am simply looking to pull data concerning users and resources. The SQL works fine. I wrapped the nsql, but it is not recognizing the syntax:

SELECT @Select:DIM:USER_DEF:IMPLIED:USER:CMN_SEC_USERS.ID:Uid@,
@Select:DIM_PROP:USER_DEF:IMPLIED:USER:CMN_SEC_USERS.USER_NAME:Uname@,
@Select:DIM_PROP:USER_DEF:IMPLIED:USER:CMN_SEC_USERS.PWD:Upwd@,
@Select:DIM_PROP:USER_DEF:IMPLIED:USER:CMN_SEC_USERS.PWD_REQUIRED:Upwdr@,
@Select:DIM_PROP:USER_DEF:IMPLIED:USER:CMN_SEC_USERS.USER_STATUS_ID:Ustat@,
@Select:DIM_PROP:USER_DEF:IMPLIED:USER:CMN_SEC_USERS.OBS_ID:Uobsid@,
@Select:DIM_PROP:USER_DEF:IMPLIED:USER:CMN_SEC_USERS.DESCRIPTION:Udesc@,
@Select:DIM_PROP:USER_DEF:IMPLIED:USER:CMN_SEC_USERS.FIRST_NAME:Ufirst@,
@Select:DIM_PROP:USER_DEF:IMPLIED:USER:CMN_SEC_USERS.MIDDLE_NAME:Umid@,
@Select:DIM_PROP:USER_DEF:IMPLIED:USER:CMN_SEC_USERS.LAST_NAME:Ulast@,
@Select:DIM_PROP:USER_DEF:IMPLIED:USER:CMN_SEC_USERS.CURRENCY_CODE:Ucurr@,
@Select:DIM_PROP:USER_DEF:IMPLIED:USER:CMN_SEC_USERS.LOGIN_COUNT:UlogCount@,
@Select:DIM_PROP:USER_DEF:IMPLIED:USER:CMN_SEC_USERS.BAD_LOGIN_COUNT:UbadCount@,
@Select:DIM_PROP:USER_DEF:IMPLIED:USER:CMN_SEC_USERS.LAST_LOGGED_IN_DATE:Ulogdate@,
@Select:DIM_PROP:USER_DEF:IMPLIED:USER:CMN_SEC_USERS.LAST_PWD_CHANGE:Upchange@,
@Select:DIM_PROP:USER_DEF:IMPLIED:USER:CMN_SEC_USERS.FORCE_PWD_CHANGE:Uforce@,
@Select:DIM_PROP:USER_DEF:IMPLIED:USER:CMN_SEC_USERS.CREATED_DATE:Ucreatedate@,
@Select:DIM_PROP:USER_DEF:IMPLIED:USER:CMN_SEC_USERS.CREATED_BY:Ucreated@,
@Select:DIM_PROP:USER_DEF:IMPLIED:USER:CMN_SEC_USERS.LAST_UPDATED_DATE:Uup@,
@Select:DIM_PROP:USER_DEF:IMPLIED:USER:CMN_SEC_USERS.LAST_UPDATED_BY:Uupby@,
@Select:DIM_PROP:USER_DEF:IMPLIED:USER:CMN_SEC_USERS.FULL_NAME:Ufull@,
@Select:DIM_PROP:USER_DEF:IMPLIED:USER:CMN_SEC_USERS.COMPANY_ID:Ucoid@,
@Select:DIM_PROP:USER_DEF:IMPLIED:USER:CMN_SEC_USERS.SQLTRACE_ACTIVE:Usql@,
@Select:DIM_PROP:USER_DEF:IMPLIED:USER:CMN_SEC_USERS.EXTERNAL_SOURCE_ID:Ux@,
@Select:DIM_PROP:USER_DEF:IMPLIED:USER:CMN_SEC_USERS.EXTERNAL_ID:Uxid@,
@Select:DIM_PROP:USER_DEF:IMPLIED:USER:CMN_SEC_USERS.IS_LDAP:Uldap@,
@Select:DIM_PROP:USER_DEF:IMPLIED:USER:CMN_SEC_USERS.USE_PROXY:Uprox@,
@Select:DIM_PROP:USER_DEF:IMPLIED:USER:CMN_SEC_USERS.START_DATE:Ustart@,
@Select:DIM_PROP:USER_DEF:IMPLIED:USER:CMN_SEC_USERS.END_DATE:Uend@,
@Select:DIM_PROP:USER_DEF:IMPLIED:USER:CMN_SEC_USERS.PROXY_USER_ID:Uproxid@,
@Select:DIM_PROP:USER_DEF:IMPLIED:USER:CMN_SEC_USERS.HOME_URL:Uurl@,
@Select:DIM_PROP:USER_DEF:IMPLIED:USER:CMN_SEC_USERS.NAV_STATE:Unavstate@,
@Select:DIM_PROP:USER_DEF:IMPLIED:USER:CMN_SEC_USERS.FAVORITE_PHOTO:Uphoto@,
@Select:DIM:USER:IMPLIED:Resource:SRM_RESOURCES.ID:RresourceID@,
@Select:DIM_PROP:USER_DEF:IMPLIED:Resource:SRM_RESOURCES.LAST_NAME:Rlast@,
@Select:DIM_PROP:USER_DEF:IMPLIED:Resource:SRM_RESOURCES.FIRST_NAME:Rfirst@,
@Select:DIM_PROP:USER_DEF:IMPLIED:Resource:SRM_RESOURCES.MIDDLE_NAME:Rmid@,
@Select:DIM_PROP:USER_DEF:IMPLIED:Resource:SRM_RESOURCES.UNIQUE_NAME:Runiq@,
@Select:DIM_PROP:USER_DEF:IMPLIED:Resource:SRM_RESOURCES.EMAIL:Remail@,
@Select:DIM_PROP:USER_DEF:IMPLIED:Resource:SRM_RESOURCES.SMS_EMAIL:Rsms@,
@Select:DIM_PROP:USER_DEF:IMPLIED:Resource:SRM_RESOURCES.PERSON_TYPE:Rtype@,
@Select:DIM_PROP:USER_DEF:IMPLIED:Resource:SRM_RESOURCES.USER_ID:Ruid@,
@Select:DIM_PROP:USER_DEF:IMPLIED:Resource:SRM_RESOURCES.DATE_OF_HIRE:Rhiredate@,
@Select:DIM_PROP:USER_DEF:IMPLIED:Resource:SRM_RESOURCES.DATE_OF_TERMINATION:Rtermdate@,
@Select:DIM_PROP:USER_DEF:IMPLIED:Resource:SRM_RESOURCES.MANAGER_ID:Rmng@,
@Select:DIM_PROP:USER_DEF:IMPLIED:Resource:SRM_RESOURCES.IS_ACTIVE:Ractive@,
@Select:DIM_PROP:USER_DEF:IMPLIED:Resource:SRM_RESOURCES.CREATED_DATE:Rcreated@,
@Select:DIM_PROP:USER_DEF:IMPLIED:Resource:SRM_RESOURCES.CREATED_BY:Rcreatedby@,
@Select:DIM_PROP:USER_DEF:IMPLIED:Resource:SRM_RESOURCES.LAST_UPDATED_DATE:Rupdate@,
@Select:DIM_PROP:USER_DEF:IMPLIED:Resource:SRM_RESOURCES.LAST_UPDATED_BY:Rupdateby@,
@Select:DIM_PROP:USER_DEF:IMPLIED:Resource:SRM_RESOURCES.FULL_NAME:Rfullname@,
@Select:DIM_PROP:USER_DEF:IMPLIED:Resource:SRM_RESOURCES.IS_EXTERNAL:Rexternal@,
@Select:DIM_PROP:USER_DEF:IMPLIED:Resource:SRM_RESOURCES.EXTERNAL_SOURCE_ID:Rxsource@,
@Select:DIM_PROP:USER_DEF:IMPLIED:Resource:SRM_RESOURCES.EXTERNAL_ID:Rxid@,
@Select:DIM_PROP:USER_DEF:IMPLIED:Resource:SRM_RESOURCES.RESOURCE_TYPE:RresourceType@,
@Select:DIM_PROP:USER_DEF:IMPLIED:Resource:SRM_RESOURCES.USE_IN_FRC_BUDGET:Rbudget@,
@Select:DIM_PROP:USER_DEF:IMPLIED:Resource:SRM_RESOURCES.SLICE_STATUS:RsliceStat@,
@Select:DIM_PROP:USER_DEF:IMPLIED:Resource:SRM_RESOURCES.INCLUDE_FLAG:Rflag@,
@Select:DIM_PROP:USER_DEF:IMPLIED:Resource:SRM_RESOURCES.BOOK_MANAGER_ID:Rbookmng@,
@Select:DIM_PROP:USER_DEF:IMPLIED:Resource:SRM_RESOURCES.ENTITY_CODE:Rentitycode@

FROM CMN_SEC_USERS
FULL JOIN SRM_RESOURCES
ON SRM_RESOURCES.USER_ID=CMN_SEC_USERS.ID

Outcomes