Tool to query the CMS repository.

security CMC
1

I need help from anybody who has used this tool to query the CMS repository.

I am trying to extract the User information like Users account name, Full name, Email address, Enabled/disabled, last login and groups a user is a member of from CMS database. I can extract all information except groups a user is member of. Even though I have a Object which calls for users groups information but when I run the object with other Objects (for which extracts user data) it returns as: “NO data to retrieve”.

Tried every way around but not able to fetch the User groiup data and users other required data together…experts plz help me…

:? :?: :frowning:

lucy.online :us: (BOB member since 2012-04-03)

2

What tool are you using? Query Builder?

Nick Daniels :uk: (BOB member since 2002-08-15)

3

Hi,

Please explain what kind of CMS querying tool you are talking about because it’s not clear from your post.

Marek Chladny :slovakia: (BOB member since 2003-11-27)

4

please check the attachments for screen shot it will give an clear view what im trying to ask…
CMS Connect screenshots1.doc (561.0 KB)

lucy.online :us: (BOB member since 2012-04-03)

5

Hi Lucy -

It appears from the screenshot that you’re using the enterprise edition of CMS/Connect - I can help you if you send me a note at my email link below.

Thanks -

Atul

Atul Chowdhury (BOB member since 2003-07-07)

6

i need extract the user data above from the CMS, can somebody say me what is the query that i have to use to extract this data

necronom1 (BOB member since 2012-08-30)