powershell - Access SQL - WMI Namespaces from Remote Machine -

-

i playing powershell , sql wmi events , wondering if can stuff remotely admin notebook:

i'd query "root\microsoft\sqlserver\serverevents\mssqlserver" namespace:

on sqlserver directly:

get-wmiobject -list -namespace "root\microsoft\sqlserver" >> works!

get-wmiobject -list -namespace "root\microsoft\sqlserver\serverevents\mssqlserver" >> works !

on adminmachine:

get-wmiobject -list -namespace "root\microsoft\sqlserver" >> works!

get-wmiobject -list -namespace "root\microsoft\sqlserver\serverevents\mssqlserver" >> error: invalid namespace.

is there trick running? have additional install sth? still on sql 2005.

thanks!

use computername name parameter.

get-wmiobject -computername z002 -list -namespace "root\microsoft\sqlserver\serverevents\mssqlserver"

also keep in mind mssqlserver available if server has default instance. if server uses named instance you'll need specify instance name instead of mssqlserver.


Comments

Post a Comment

Popular posts from this blog

List<T>().Add problem C# -

-
i made list hold object in it, , i'll read it. if give index list, same object results. here code: list<tempids> treedids = new list<tempids>(); tempids tempids = new tempids(); foreach (itemgrouptreed treed in itemtreedcoll) { //idleri listeye alıyoruz daha sonra karşılaştırma yapmak için tempids.treedid = treed.id; tempids.treeparentid = treed.treeparentid; treedids.insert(treedids.count, tempids); //---- //eğer ilk gelen detay id ile methoda gelen id bir ise collectiona ekliyoruz. if (tempids.treedid == grouptreedid) { treedtempcoll.add(treed); } else { //burada karşılaştırma yapıyoruz. (int = 0; < treedids.count; i++) { if (tempids...
Read more

Javascript natural sort array/object and maintain index association -

-
i have array of items follows in javascript: var users = array(); users[562] = 'testuser3'; users[16] = 'testuser6'; users[834] = 'testuser1'; users[823] = 'testuser4'; users[23] = 'testuser2'; users[917] = 'testuser5'; i need sort array following output: users[834] = 'testuser1'; users[23] = 'testuser2'; users[562] = 'testuser3'; users[823] = 'testuser4'; users[917] = 'testuser5'; users[16] = 'testuser6'; notice how sorted value of array , value-to-index association maintained after array sorted (that critical). have looked solution this, tried making it, have hit wall. by way, aware technically not array since mean indices iterating 0 through n n+1 counting number proceeding n. define it, requirement project still same. also, if makes difference, not using jquery. the order of elements of array defined index. if specify values in different order, values stored in or...
Read more