andyya Posted December 15, 2021 Report post Posted December 15, 2021 Is this a correct query to find log4j*.jar file in C drive? select SMS_R_System.ResourceId, SMS_R_System.ResourceType, SMS_R_System.Name, SMS_R_System.SMSUniqueIdentifier, SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.Client from SMS_R_System inner join SMS_G_System_SoftwareFile on SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SoftwareFile.FilePath like "C:\\" and SMS_G_System_SoftwareFile.FileName like "log4j*.jar" Quote Share this post Link to post Share on other sites More sharing options...
GarthMJ Posted December 15, 2021 Report post Posted December 15, 2021 What isn't working with this query? aka why are you looking for help? Quote Share this post Link to post Share on other sites More sharing options...