Author Posts

December 8, 2014 at 2:57 am

Hi Guys,

Really stupid question, but having a bit of trouble with selecting properties for display as below:

get-cmdevice -Name DeviceName | Select Name,Username,LastActiveTime

All I get returned is the headers Name, Username, LastActiveTime. What am I missing, I know it's something simple...

THanks

December 8, 2014 at 4:41 am

What output do you get if you just enter :

get-cmdevice -Name DeviceName 

?

December 8, 2014 at 5:09 am

I get a return of all the attributes of the dvice, including Name, username and LastActiveTime

December 8, 2014 at 5:56 am

Those are probably not the actual property names, they're probably just table headers.

Get-CmDevice -Name DeviceName | Get-Member

To verify the actual property names, which is what you must use with Select-Object.

December 8, 2014 at 6:00 am

Thanks for the reply, Don. I tried that already, but I don't see an alternative name from the output below. Any ideas?

LastActiveTime                           Property              Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlResultObject LastActiveTime {get;set;}                                                    
LastClientCheckTime                      Property              Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlResultObject LastClientCheckTime {get;set;}                                               
LastDDR                                  Property              Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlResultObject LastDDR {get;set;}                                                           
LastHardwareScan                         Property              Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlResultObject LastHardwareScan {get;set;}                                                  
LastInstallationError                    Property              Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlResultObject LastInstallationError {get;set;}                                             
LastMPServerName                         Property              Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlResultObject LastMPServerName {get;set;}                                                  
LastPolicyRequest                        Property              Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlResultObject LastPolicyRequest {get;set;}                                                 
LastSoftwareScan                         Property              Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlResultObject LastSoftwareScan {get;set;}                                                  
LastStatusMessage                        Property              Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlResultObject LastStatusMessage {get;set;}                                                 
LastSuccessSyncTimeUTC                   Property              Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlResultObject LastSuccessSyncTimeUTC {get;set;}                                            
LatestProcessingAttempt                  Property              Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlResultObject LatestProcessingAttempt {get;set;}                                           
Name                                     Property              Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlResultObject Name {get;set;}                        

December 8, 2014 at 6:07 am

Well, I don't see UserName there, but assuming that was truncated output. Name and LastActiveTime should work.

If you can pipe the output to Select *, then you should be able to pipe it to Select with a list of valid property names. If it doesn't, then sitting here I've no idea why that would be the case.

December 8, 2014 at 6:31 am

Sorry should have mentioned that I truncated the output from gm as there are about 50 returned items. This is the output when pipe to select *

get-cmdevice -name DeviceName | select *
ADLastLogonTime                          : 
ADSiteName                               : 
AMTFullVersion                           : 
AMTStatus                                : 
ClientActiveStatus                       : 1
ClientCertType                           : 1
ClientCheckPass                          : 1
ClientEdition                            : 0
ClientRemediationSuccess                 : 1
ClientType                               : 1
ClientVersion                            : 5.00.7958.1000
DeviceAccessState                        : 
DeviceOS                                 : Microsoft Windows NT Workstation 6.3
DeviceOwner                              : 1
DeviceType                               : 
Domain                                   : 
EASDeviceID                              : 
EnrollmentStatus                         : 
EPAntispywareEnabled                     : True
EPAntispywareSignatureLastUpdateDateTime : 08/12/2014 02:13:03
EPAntispywareSignatureLastVersion        : 1.189.1596.0
EPAntivirusEnabled                       : True
EPAntivirusSignatureLastUpdateDateTime   : 08/12/2014 02:13:03
EPAntivirusSignatureLastVersion          : 1.189.1596.0
EPClientVersion                          : 4.6.305.0
EPDeploymentDescription                  : 
EPDeploymentErrorCode                    : 0
EPDeploymentState                        : 3
EPEnabled                                : True
EPEngineVersion                          : 1.1.11202.0
EPInfectionStatus                        : 2
EPLastFullScanDateTimeEnd                : 21/11/2014 18:20:27
EPLastFullScanDateTimeStart              : 08/12/2014 10:34:46
EPLastInfectionTime                      : 
EPLastQuickScanDateTimeEnd               : 21/11/2014 11:09:39
EPLastQuickScanDateTimeStart             : 08/12/2014 08:49:49
EPLastThreatName                         : 
EPPendingFullScan                        : False
EPPendingManualSteps                     : False
EPPendingOfflineScan                     : False
EPPendingReboot                          : False
EPPolicyApplicationDescription           : 
EPPolicyApplicationErrorCode             : 0
EPPolicyApplicationState                 : 1
EPProductStatus                          : 0
ExchangeOrganization                     : 
ExchangeServer                           : 
IsActive                                 : True
IsAlwaysInternet                         : False
IsAOACCapable                            : False
IsApproved                               : 1
IsBlocked                                : False
IsClient                                 : True
IsInternetEnabled                        : False
IsObsolete                               : False
IsVirtualMachine                         : False
LastActiveTime                           : 08/12/2014 13:12:41
LastClientCheckTime                      : 22/11/2014 19:59:14
LastDDR                                  : 05/12/2014 15:10:57
LastHardwareScan                         : 05/12/2014 15:24:30
LastInstallationError                    : 
LastMPServerName                         : 
LastPolicyRequest                        : 08/12/2014 13:12:41
LastSoftwareScan                         : 
LastStatusMessage                        : 
LastSuccessSyncTimeUTC                   : 
LatestProcessingAttempt                  : 
Name                                     : 
PhoneNumber                              : 
PolicyApplicationStatus                  : 
ResourceID                               : 16777548
ResourceType                             : 5
RetireStatus                             : 
SiteCode                                 : CCM
SMSID                                    : GUID:9DD63644-849D-432C-91B1-FB8A89908AB5
Status                                   : 
SuppressAutoProvision                    : 
Unknown                                  : False
UserDomainName                           : CAN
UserName                                 : MyUserName
WipeStatus                               : 
ManagedObject                            : \\CANSCCM01\root\sms\site_CCM:SMS_CombinedDeviceResources.ResourceID=16777548
EmbeddedProperties                       : {}
EmbeddedPropertyLists                    : {}
OverridingObjectClass                    : SMS_CombinedDeviceResources
RegMultiStringLists                      : {}
SecurityVerbs                            : 1342176935
GenericsArray                            : 
Generics                                 : 
Count                                    : 1
DisplayString                            : 
DisplayDescription                       : 
HelpTopic                                : 
ObjectClass                              : SMS_CombinedDeviceResources
Properties                               : [SecurityVerbs(1342176935)]
                                           instance of SMS_CombinedDeviceResources
                                           {
                                               ADSiteName = "";
                                               ClientActiveStatus = 1;
                                               ClientCertType = 1;
                                               ClientCheckPass = 1;
                                               ClientEdition = 0;
                                               ClientRemediationSuccess = 1;
                                               ClientType = 1;
                                               ClientVersion = "5.00.7958.1000";
                                               DeviceOS = "Microsoft Windows NT Workstation 6.3";
                                               DeviceOwner = 1;
                                               Domain = "";
                                               EPAntispywareEnabled = TRUE;
                                               EPAntispywareSignatureLastUpdateDateTime = "20141208021303.000000+***";
                                               EPAntispywareSignatureLastVersion = "1.189.1596.0";
                                               EPAntivirusEnabled = TRUE;
                                               EPAntivirusSignatureLastUpdateDateTime = "20141208021303.000000+***";
                                               EPAntivirusSignatureLastVersion = "1.189.1596.0";
                                               EPClientVersion = "4.6.305.0";
                                               EPDeploymentDescription = "";
                                               EPDeploymentErrorCode = 0;
                                               EPDeploymentState = 3;
                                               EPEnabled = TRUE;
                                               EPEngineVersion = "1.1.11202.0";
                                               EPInfectionStatus = 2;
                                               EPLastFullScanDateTimeEnd = "20141121182027.803000+***";
                                               EPLastFullScanDateTimeStart = "20141208103446.917000+***";
                                               EPLastQuickScanDateTimeEnd = "20141121110939.470000+***";
                                               EPLastQuickScanDateTimeStart = "20141208084949.460000+***";
                                               EPPendingFullScan = FALSE;
                                               EPPendingManualSteps = FALSE;
                                               EPPendingOfflineScan = FALSE;
                                               EPPendingReboot = FALSE;
                                               EPPolicyApplicationDescription = "";
                                               EPPolicyApplicationErrorCode = 0;
                                               EPPolicyApplicationState = 1;
                                               EPProductStatus = 0;
                                               IsActive = TRUE;
                                               IsAlwaysInternet = FALSE;
                                               IsAOACCapable = FALSE;
                                               IsApproved = 1;
                                               IsBlocked = FALSE;
                                               IsClient = TRUE;
                                               IsInternetEnabled = FALSE;
                                               IsObsolete = FALSE;
                                               IsVirtualMachine = FALSE;
                                               LastActiveTime = "20141208131241.000000+***";
                                               LastClientCheckTime = "20141122195914.937000+***";
                                               LastDDR = "20141205151057.000000+***";
                                               LastHardwareScan = "20141205152430.000000+***";
                                               LastMPServerName = "";
                                               LastPolicyRequest = "20141208131241.000000+***";
                                               Name = "";
                                               ResourceID = 16777548;
                                               ResourceType = 5;
                                               SiteCode = "CCM";
                                               SMSID = "GUID:9DD63644-849D-432C-91B1-FB8A89908AB5";
                                               Unknown = FALSE;
                                               UserDomainName = "";
                                               UserName = "";
                                           };
                                           
PropertyNames                            : {ADLastLogonTime, ADSiteName, AMTFullVersion, AMTStatus...}
MethodNames                              : 
MethodList                               : {}
PropertyList                             : {[ADLastLogonTime, ], [ADSiteName, ], [AMTFullVersion, ], [AMTStatus, ]...}
UniqueIdentifier                         : f3bf93d6-a4f2-490b-9155-61c69336ee04
ParentResultObject                       : 
GlobalDisplayString                      : 
AutoCommit                               : False
AutoRefresh                              : False
UserDataObject                           : 
ConnectionManager                        : Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlConnectionManager
TraceProperties                          : True
NamedValueDictionary                     : {[ProviderLocation, \\\ROOT\sms:SMS_ProviderLocation.Machine="",SiteCode="CCM"], [ProviderMachineName, ], 
                                           [AllProviderLocations, System.Collections.Generic.List`1[System.Management.ManagementObject]], [Connection, \\\root\sms\site_CCM]...}
AsyncOperationData                       : 
RetainObjectLock                         : False

I removed some of my personal info. Strange one...

This is what I get from the original select

 PS CCM:\> get-cmdevice -Name MyDevice | Select-object name,username,lastactivetime

name                                                                       username                                                                   lastactivetime                                                            
----                                                                       --------                                                                   --------------                                                            
                                                                                                                                                                                                                                



PS CCM:\> 

December 8, 2014 at 7:09 am

Argh. It's case sensitive. When selecting properties, you need to mind your capitalisation!

Kudos to Dexter:

http://www.dexterposh.com/2014/04/powershell-sccm-2012-r2-get-client-info.html

Thanks for your input guys