SOLVED WQL Query need

[tata789]

hello
I am not very good WQL Query and I am looking WQL query to get, I can not run SQL I do not heave access to SQL box or data base
Computer Name
User Name
IP address
Memory
OS type
Model type

any help will be great
thank you
Arun

 

[Garth]

Have you tried to write this yourself using the GUI? As a CM admin, you should get at minimum read only access the the database, otherwise you will never be able to create reports,

 

[tata789]

I try to get read access but SQL team not giving read access and they say this is company policy and just do WQL Query and I am need badly this report
thank you
Arun

 

[tata789]

hello
I made it work, but I am not able to get user name if you can help me that will be good and I will try to, and this is the WQL Query I did

elect distinct
SMS_R_System.NetbiosName,
SMS_G_System_PC_BIOS.SerialNumber, SMS_G_System_X86_PC_MEMORY.TotalPhysicalMemory,
SMS_R_System.IPAddresses, SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.DNSDomain
from SMS_R_System inner join SMS_G_System_PC_BIOS
on SMS_G_System_PC_BIOS.ResourceID = SMS_R_System.ResourceId
inner join SMS_G_System_X86_PC_MEMORY
on SMS_G_System_X86_PC_MEMORY.ResourceID = SMS_R_System.ResourceId
inner join SMS_G_System_NETWORK_ADAPTER_CONFIGURATION
on SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.ResourceID = SMS_R_System.ResourceId
order by SMS_R_System.NetbiosName

thank you
Arun

 

[tata789]

hello
you can mark as resolved , I make it work
thanks to everyone to help
thank you
Arun

 

[Garth]

Not everything can don via WQL.
If you don't have access to SQL then you more or less can't create reports for your managment. And therefore it is up to the SQL team to write the SSRS report for you and your management team.

As an aside, you have full access to the SQL db if your know the SSRS execution account PW, as it will have access to everything you should be able to access within the db.

 

[tata789]

that is I know but is my luck I do not have SQL access even read access , if I had read access I can run the SQL Query and it will be no issue but that is a life.
some time SQL team thing they are the god and this point cannot do anything
I like to thank you for your help and I manage to do some WQL Query
you can mark as solved
thank you
Arun