Выборка свойств WMI класса

Используется в проекте Hardwareinfo.

SELECT tbComputerTarget.Name, tbInventoryClass.Name AS ClassName, tbInventoryProperty.Name AS PropertyName,
 tbComputerInventory.Value, tbComputerInventory.InstanceId
    FROM tbComputerInventory INNER JOIN
        tbInventoryClass ON tbComputerInventory.ClassID = tbInventoryClass.ClassID INNER JOIN
        tbInventoryProperty ON tbComputerInventory.PropertyID = tbInventoryProperty.PropertyID INNER JOIN
        tbComputerTarget ON tbComputerInventory.ComputerTargetId = tbComputerTarget.ComputerTargetId
    WHERE  (tbComputerTarget.Name = 'l016.pshome.local');

Представления в БД Inventory

Используется в проекте Reports.

SELECT tbComputerTarget.Name AS `Name`, tbInventoryClass.Name AS `ClassName`, tbInventoryProperty.Name AS `PropertyName`, tbComputerInventory.Value AS `Value`, tbComputerInventory.InstanceId AS `InstanceId`
 FROM (((tbComputerInventory
  JOIN tbInventoryClass on((tbComputerInventory.ClassID = tbInventoryClass.ClassID)))
   JOIN tbInventoryProperty on((tbComputerInventory.PropertyID = tbInventoryProperty.PropertyID)))
    JOIN tbComputerTarget on((tbComputerInventory.ComputerTargetId = tbComputerTarget.ComputerTargetId)))
     ORDER BY tbComputerTarget.Name;


SELECT tbComputerTarget.Name AS `Name`,
 tbInventoryProperty.Name AS `PropertyName`,
  tbComputerSoftInventory.Value AS `Value`,
   tbComputerSoftInventory.InstanceId AS `InstanceId`
 FROM ((tbComputerSoftInventory
   JOIN tbInventoryProperty on((tbComputerSoftInventory.PropertyID = tbInventoryProperty.PropertyID)))
    JOIN tbComputerTarget on((tbComputerSoftInventory.ComputerTargetId = tbComputerTarget.ComputerTargetId)))
     ORDER BY tbComputerTarget.Name;

SELECT tbComputerTarget.Name AS `Name`,
 tbInventoryProperty.Name AS `PropertyName`,
  tbComputerUpdatesInventory.Value AS `Value`,
   tbComputerUpdatesInventory.InstanceId AS `InstanceId`
 FROM ((tbComputerUpdatesInventory
   JOIN tbInventoryProperty on((tbComputerUpdatesInventory.PropertyID = tbInventoryProperty.PropertyID)))
    JOIN tbComputerTarget on((tbComputerUpdatesInventory.ComputerTargetId = tbComputerTarget.ComputerTargetId)))
     ORDER BY tbComputerTarget.Name;

Текущие запросы (процессы)

SHOW FULL PROCESSLIST;

Замена подстроки

UPDATE items
SET Dimensions = REPLACE(Dimensions, '×', 'x');