/build/static/layout/Breadcrumb_cap_w.png

Data rule

Good Day

Can anybody help me with a data rule that gets the size and date modified of test.dll found in c:\program files\temp\test.dll? Is it then possible to get a report that gives me this info for all my computers?

Regards,
Anthony

0 Comments   [ + ] Show comments

Answers (2)

Posted by: airwolf 14 years ago
Red Belt
1
I believe you are referring to a custom inventory rule.

FileInfoReturn(c:\program files\temp\test.dll,ModifiedDate,DATE)

That will get you the modified date, but I don't know of any way to query file size on a Windows system. The Unix (Mac OS X) FileInfoReturn can return file size, but the Windows attributes are as follows:

attribute on windows can be: Comments, Language , CompanyName, LegalCopyright , FileBuildPart, LegalTrademarks , FileDescription, OriginalFilename , FileMajorPart, PrivateBuild , FileMinorPart, ProductBuildPart , FileName, ProductMajorPart , FilePrivatePart, ProductMinorPart , FileVersion, ProductName , InternalName, ProductPrivatePart , IsDebug, ProductVersion , IsPatclhed, SpecialBuild , IsPreRelease, CreatedDate , IsPrivateBuild, ModifiedDate , IsSpecialBuild, AccessedDate


EDIT: I'd also like to note that you'll have to create a separate custom inventory rule for each attribute you want to query. You cannot pull two file attributes in the same inventory rule.

Comments:
  • hi there Airwolf

    how are you doing

    i have created a separate custom inventory rule

    please assist me as i not winning with the fileinforeturn .dll file

    this is what it looks like:

    inventory rule:
    FileInfoReturn(c:\program files\I-Systems\Scanning Client\ISystems.JDGroup.ScanningSolution.DealDocumentationPlugin.dll,ModifiedDate,2011/09/08)

    I am not sure if the inventory rule is correct but any way what i am trying to achieve is to pull a report to see in the .dll file is installed or not in our Kace environment.

    i can see that in the Smart lable contense that it is added as a Custom Field (name Deal Documentation)
    and i can see that it is added to the Tab Reports Custom Field too

    Regards
    burton - burtono 11 years ago
    • I haven't worked with the K1000 in almost a year, so I apologize if I'm a bit rusty. At first glance, it appears your rule isn't written properly. The last parameter should literally be the word 'DATE' not a specific date - it's the type parameter to tell the function to return the ModifiedDate in DATE format. You should be able to report based on machines that have a valid value returned by this function. - airwolf 11 years ago
  • hi airwolf

    i tried it and it does not work


    Client\ISystems.JDGroup.ScanningSolution.DealDocumentationPlugin.dll,ModifiedDate,DATE)

    The report does how ever pull the report but giving me an ip address,name but not giving me a date

    any other way i can pull the dll file?

    regards
    burton - burtono 11 years ago
    • I don't know if your rule was written incorrectly or if you copy/pasted wrong, but you're missing the first portion of the function in what you pasted. As for the report, you have to specify which fields you want to display. Your results need to be restricted within the query. Are you using the reporting wizard or did you write your own SQL? - airwolf 11 years ago
  • hi Airwolf

    thanks for getting back to me

    i am using the wizard - burtono 11 years ago
    • You will most likely have to write a custom SQL rule - unless major improvements to the wizard have been made lately. I'd assist with writing the SQL, but I don't have access to a K1000 database at the moment to view the needed tables. - airwolf 11 years ago
  • FileInfoReturn(c:\programfiles\I-systems\ScanningClient\ISystems.JDGroup.ScanningSolution.DealDocumentationPlugin.dll,ModifiedDate,DATE)

    here is the full portion

    regards - burtono 11 years ago
Posted by: anthonyw 14 years ago
Orange Senior Belt
0
Thank you for the feedback. If anyone know of a way to get the file size please assist.
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ