Need to type Query in command prompt by using Type Into Activity

Learning Hub
1

Hi,

I need to type the below query in comman prompt by using type into activity but i am gettinng errors. can anyone help me out?

dsquery * -filter “(&(objectcategory=person)(employeeid= ))”

2

@shyam.sankar

What was the error you are facing?

3

hi @shyam.sankar
I have created basic workflow, type into is working.OpenCMD_RunCommand.xaml (6.9 KB)

  1. Win + R (Run)
  2. Type cmd then enter
  3. change directory
    4.Close Cmd

Thanks
Latika

4

Thank you!

6

I didn’t get the exact solution for my problem…Actually i need to type this query in cmd by type into activity to get the details of the employee

dsquery * -filter “(&(objectcategory=person)(employeeid= ID))”

ID- i will replace the value from variable…

While entering this query i am getting one small error…I guess its very basic mistake but i couldn’t find
Can you help me out please?

7

Small validation error

8

can you share the error screenshot?

9

dsquery * -filter “(&(objectcategory=person)(employeeid= ID))”

ID should be variable, but in Command prompt it shoud be %ID%.
Can you please Run the query once manually in cmd. if the output came then no problm with query.

Example:
Reading Value from a Variable in Cmd,

C:\> SET foo=bar
C:\> ECHO %foo%
bar

Thanks
Latika

10

Hi,

Please find the attached screenshot

image.png
image.png1561×664 64.3 KB

11

@shyam.sankar

Check as below

image
image739×162 4.51 KB

You are missing the double quote at end

Hope this helps

Thanks

12

Write the full Query in between " "
Type into allows string type.

Thanks
Latika

13

I have already tried with “” but same error.

image.png

14

“dsquery * -filter“(&(objectcategory=person)(employeeid=ID))”

(or)

“dsquery * -filter (&(objectcategory=person)(employeeid=ID))”

image
image770×356 21.7 KB

Thanks
Latika

15

Double quotes between the query is mandatory.Below is the exact structure of the query.I have tried yours but not working.Please do the needful

dsquery * -filter “(&(objectcategory=person)(employeeid= ID))”

16

Any update?

17

Hi @shyam.sankar

Just paste the below line and check
“dsquery * -filter “+” “”(&(objectcategory=person)(employeeid= ID))”" "

18

While typing the above query i am not getting errors,its fine.
But the value in the variable is not typing in CMD…Its just simply typing ID…

19

Can you please change ID as %ID% and check it once.
Let me know if you found any errors.

Thanks
Latika

20

Hi @shyam.sankar

By assign and replace you can change the ID
e.g.

Assign
query = “dsquery * -filter “+” “”(&(objectcategory=person)(employeeid= ID))”" "
ID = 32

Then use
query.Replace(“ID”,ID.ToString)

21

Its working fine…Thanks for the great help!!!