I beleive that v_GS_SYSTEM_ENCLOSURE_UNIQUE.AssetTag should
be v_GS_SYSTEM_ENCLOSURE_UNIQUE.Tag0.
vSMS_R_System.description0 also does not exist, but I am not sure which
field you are looking for. These are the fields for vSMS_R_SYSTEM:
[ItemKey]
,[DiscArchKey]
,[SMS_Unique_Identifier0]
,[Netbios_Name0]
,[Name0]
,[Distinguished_Name0]
,[Operating_System_Name_and0]
,[Resource_Domain_OR_Workgr0]
,[AD_Site_Name0]
,[User_Name0]
,[Client0]
,[Client_Type0]
,[Unknown0]
,[Client_Version0]
,[Community_Name0]
,[User_Domain0]
,[Previous_SMS_UUID0]
,[SMS_UUID_Change_Date0]
,[CPUType0]
,[Hardware_ID0]
,[Obsolete0]
,[Active0]
,[Creation_Date0]
,[SMBIOS_GUID0]
,[AlwaysInternet0]
,[InternetEnabled0]
,[Decommissioned0]
,[WipeStatus0]
,[AMTStatus0]
,[AMTFullVersion0]
,[IsClientAMT30Compatible0]
,[SuppressAutoProvision0]
,[Primary_Group_ID0]
,[User_Account_Control0]
,[SID0]
,[EAS_DeviceID]
,[Object_GUID0]
,[Last_Logon_Timestamp0]
,[Is_Virtual_Machine0]
,[Is_MachineChanges_Persisted0]
,[Is_Assigned_To_User0]
,[Virtual_Machine_Host_Name0]
,[rowversion]
,[AgentEdition0]
,[WTGUniqueKey]
,[Is_Write_Filter_Capable0]
,[Is_Portable_Operating_System0]
,[Is_AOAC_Capable0]
,[PublisherDeviceID]
,[operatingSystem0]
,[operatingSystemServicePac0]
,[managedBy0]
,[operatingSystemVersion0]
,[Full_Domain_Name0]
,[DeviceOwner0]
,[IsReassigned0]
-----
Dwayne Allen
[email protected]
(479) 310-0027
On Tue, Mar 24, 2015 at 1:23 PM, Murray, Mike <[email protected]> wrote:
> I’m trying to use this to create a report. When I run the report, I get:
>
>
>
> - An error has occurred during report processing. (rsProcessingAborted)
>
> Query execution failed for dataset 'DataSet1'. (rsErrorExecutingCommand)
>
>
>
>
>
> Here’s the SQL:
>
>
>
> select distinct
> SMS_R_System.ItemKey,SMS_G_System_PC_BIOS.SerialNumber00,v_GS_SYSTEM_ENCLOSURE_UNIQUE.AssetTag,SMS_R_System.Name0,SMS_R_System.Client_Version0,SMS_R_System.Distinguished_Name0,SMS_R_System.operatingSystem0,SMS_R_System.operatingSystemServicePac0,SMS_R_System.Last_Logon_Timestamp0,___System_WORKSTATION_STATUS3.LastHWScan,SMS_G_System_COMPUTER_SYSTEM.Manufacturer00,SMS_G_System_COMPUTER_SYSTEM.Model00,SMS_G_System_COMPUTER_SYSTEM.TotalPhysicalMemory00,SMS_G_System_OPERATING_SYSTEM.InstallDate00,SMS_G_System_OPERATING_SYSTEM.LastBootUpTime00,__ystem_SYSTEM_CONSOLE_USAGE1.TopConsoleUser00,SMS_R_System.User_Name0,SMS_R_System.User_Domain0,SMS_G_System_PC_BIOS.SMBIOSBIOSVersion00,___System_ENCRYPTABLE_VOLUME2.DriveLetter00,___System_ENCRYPTABLE_VOLUME2.ProtectionStatus00,SMS_G_System_OPERATING_SYSTEM.Description00,SMS_R_System.description0
>
> from vSMS_R_System AS SMS_R_System LEFT OUTER JOIN
> System_System_OU_Name_ARR AS __mSystem_System_OU_Name_ARR0 ON
> SMS_R_System.ItemKey = __mSystem_System_OU_Name_ARR0.ItemKey LEFT OUTER
> JOIN Computer_System_DATA AS SMS_G_System_COMPUTER_SYSTEM ON
> SMS_G_System_COMPUTER_SYSTEM.MachineID = SMS_R_System.ItemKey LEFT OUTER
> JOIN Operating_System_DATA AS SMS_G_System_OPERATING_SYSTEM ON
> SMS_G_System_OPERATING_SYSTEM.MachineID = SMS_R_System.ItemKey LEFT OUTER
> JOIN PC_BIOS_DATA AS SMS_G_System_PC_BIOS ON SMS_G_System_PC_BIOS.MachineID
> = SMS_R_System.ItemKey LEFT OUTER JOIN SYSTEM_CONSOLE_USAGE_DATA AS
> __ystem_SYSTEM_CONSOLE_USAGE1 ON __ystem_SYSTEM_CONSOLE_USAGE1.MachineID =
> SMS_R_System.ItemKey LEFT OUTER JOIN ENCRYPTABLE_VOLUME_DATA AS
> ___System_ENCRYPTABLE_VOLUME2 ON ___System_ENCRYPTABLE_VOLUME2.MachineID =
> SMS_R_System.ItemKey LEFT OUTER JOIN WorkstationStatus_DATA AS
> ___System_WORKSTATION_STATUS3 ON ___System_WORKSTATION_STATUS3.MachineID =
> SMS_R_System.ItemKey
>
> where (SMS_R_System.Obsolete0 = N'0') order by name0
>
>
>
>
>
>
>
> Best Regards,
>
>
>
> Mike Murray
>
> Desktop Management Coordinator - IT Support Services
>
> California State University, Chico
>
> 530.898.4357
> [email protected]
>
>
>
>
