🤘 7 reputation

ShaneCorellian

Administrator

Joined: 10/21/2009

Last seen: 8/14/2018

Activity
  • Good question. It is important to remember that a machine can (and often does) maintain multiple versions of the MS Visual C++ Runtime. Some applications require a specific version of the Runtime so Microsoft makes sure to not "upgrade" but to merely place versions next to each other. It's a compatibility thing.

    This collection is meant to let people know that computers in this collection do have the latest version as well as older versions. Basically it is FYI. We recommend that you use the Old or Not Installed collections as deployment sources (depending on your need).

  • Thanks for the offer, Robert. When we get to that point we may reach out. These major changes always increase the ol' blood pressure so we are grateful for the offer.

  • Hi Robert,

    You are correct in the fact that your environment is stressing out SQLite beyond its limits.

    The short answer is Yes. In all candor we are seriously examining Microsoft SQL. Before we ever implement such a big move several requirements must be met. I won't go into all of them here but first and foremost is the seamless (or as near to seamless as possible) upgrade of existing SQLite DBs.

    I will not provide expected dates on this move. The DB issue has our attention and not just in the passive sense.

    -Shane

  • Directed Broadcasts are ideal however we have put a feature in PDQ Inventory that basically utilizes another online target computer (a helper, if you will) that resides in the same subnet. After the broadcast and directed broadcasts go out Inventory will attempt to find a helper computer in that same remote subnet. It will then instruct that other computer to send out a basic WOL magic packet. In addition to the usual external dependencies that exist with WOL (BIOS, NIC settings, etc) there are two caveats:

    • The helper machine must reside in Inventory and be on the same subnet that is recorded in Inventory. If the "helper" machine has moved since the last scan it won't be much help.
    • The helper machine must use the same subnet mask as the machine it is attempting to wake up. This is usually the case but we have seen some instances where an organization uses different subnet masks across their network and these instances don't allow this last step to work.
  • The collections are updated in a background process that constantly runs. Large environments take a little longer. However, when a collection is referenced it is pushed to the front of the refresh queue. “Referenced” means selecting the collection in the console, running a deployment to the collection via schedule, choosing deployment targets by collection, Auto Reports that reference the collection, etc. Actually all collection membership is processed this way. To verify this you can run a deployment to a collection. Doing this wil cause the collection membership to be updated. Look at the targets of the deployment. Then open that same collection in PDQ Inventory and the members you see should match the deploy targets.

  • Definitely recommended to have both installed on the same machine. This way they can communicate with (and compliment) each other. On the same machine you can have PDQ Deploy target PDQ Inventory collections or have Inventory keep track of deployments at the computer level. When they exist on separate machines they are effectively just stand alone applications that don't interface with each other.

  • Steve,

    Your filters should do the job. Another option would be to use a filter using Does Not Match Expression with the value 4\.6\.2|4\.7

    The backslash is used to escape the dot character. The pipe is an OR. This basically says return computers that do not contain 4.6.2 or 4.7 (no need to elaborate 4.7.1, etc since 4.7 is already higher than 4.6.2)

  • Hi Adam,

    You need to use the Group Filters to do this. This article should help you find exactly what you're looking for.

     

  • The Preferences menu item has been moved to the Options menu. You can also access via the CTRL+, shortcut.

    There are quite a few changes that were introduced in version 13 (and even more in 14 and 15). You can always see the changes in the Update Notes of the User Guide. (Help > User Guide).

  • Multiple triggers are considered "OR". Each trigger will kick off a scan.

  • Make sure you have two filters. One for the Application Name and one for the Application Version.

    The attached image shows the Silverlight (Old) collection from the Collection Library. We are using System Variables. The mouse is hovering over the top (x) so that the variable is expanded.

  • Hi Ashley,

    Please attach a screenshot of the filters in your collection. Here is an example of a collection which shows computers that do not Intune installed as a service. I don't have intune in my environment so I can't verify that this works. I did replace Intune with another service that we have here to verify that the logic of the filters works. Make sure the two sub group filters are on the same level. Basically when you create each sub group make sure you have the top group (All) selected. Then place the value filters the appropriate group filter.

  • PDQ is an abbreviation that is generally understood to stand for Pretty Damn Quick. 

    When I was 12 I had a teacher who used the term a lot. "Shane, you'd better turn in that assignment PDQ!"

     

  • Please verify that the version of .NET you are installing is compatible with the OS. 4.5.2 or later cannot be installed on XP and .NET 4.7.1+ will not install on Vista, 8 or first two releases of Win 10.

  • Thanks, Erik.

    I just realized that the image I originally uploaded contained the default filter of Computer Name Contains <blank>. I corrected the image. That filter itself wouldn't cause a problem but it is unnecessary so I removed it from the example.

  • After you have scanned computers with your new or modified scan profile you can apply filters in your collections or reports using the File filter. The image below shows a collection which will only contain computers that have a file called Ops Manual.pdf in at least one Desktop folder under the Users directory. 

  • Hi Pascal,

    XnView has been added to the Collection Library under Applications > Imaging. Your console will automatically show the collection within 2 hours. If you want to see it faster go to the main Collection Library node and click the Sync button. You can also close and reopen PDQ Inventory to force a refresh.

    Thanks for the suggestion,

    -Shane

  • Hi Christian,

    We have added IrfanView to the Collection Library. The IrfanView collection has been placed under Applications > Imaging. If you don't see it then select Collection Library and click the Sync Now button. 

    Thanks for the suggestion. 

    -Shane

  • Sorry for the oversight. Refresh your Collection Library. The variable has been updated.

  • You were really close, Stephen. The problem with those collections is that the sub collections are evaluating any application to be lower (or higher) than 3.3.2. You still need to have a filter for Application Name.

    You are using the Drill Down but remember that using Drill Down means that this collection will only evaluate computers that are in the parent collection. If you have 3,000 computers in your database but only 30 have PDFSam then a sub collection with Drill Down enabled will only evaluate its respective filters against those 30 computers. It does not, however, pass the filters from the parent down to the sub collection it only passes the collection members.

    Keith, PDFSam is also one of those applications that actually reports a slightly different version in Inventory than the "friendly" version shown on their website. PDFSam version 3.3.2 is actually reported as 3.30.2.0.

    I also created a custom variable for you. When the next version of PDFSam comes out you will only need to update the one variable called @(AppVerPDFSam). In Inventory 13 you can access variables from the Options > Variables menu. Inventory 12.4 and earlier you can go to File > Preferences > Variables.

    You can copy the xml below and create a new XML file. Then follow Stephen's instructions for importing it. The variable (if it doesn't already exist) will be created.

     

    <?xml version="1.0" encoding="utf-8"?>
    <AdminArsenal.Export Code="PDQInventory" Name="PDQ Inventory" Version="13.1.0.0" MinimumVersion="4.0">
    <Collection>
    <ReportDefinition name="Definition">
    <RootFilter name="Filter">
    <Comparison>All</Comparison>
    <Filters type="list">
    <ValueFilter>
    <Table>Application</Table>
    <Column>Name</Column>
    <Comparison>Contains</Comparison>
    <Value>PDFSam</Value>
    </ValueFilter>
    </Filters>
    </RootFilter>
    <ReportDefinitionTypeName>BasicReportDefinition</ReportDefinitionTypeName>
    <Columns type="list">
    <Column>
    <Column>ComputerId</Column>
    <Summary></Summary>
    <Table>Computer</Table>
    <Title></Title>
    </Column>
    </Columns>
    </ReportDefinition>
    <IsDrilldown value="false" />
    <CanShare value="null" />
    <Created>2017-06-26T06:41:53.0000000-06:00</Created>
    <Description></Description>
    <Error></Error>
    <Id value="7367" />
    <ImportedPath></ImportedPath>
    <IsEnabled value="true" />
    <Modified>2017-06-26T06:42:17.0000000-06:00</Modified>
    <Name>PDFSam</Name>
    <ParentId value="null" />
    <Path>PDFSam</Path>
    <TypeName>DynamicCollection</TypeName>
    <Type>DynamicCollection</Type>
    <Children type="list">
    <Collection>
    <ReportDefinition name="Definition">
    <RootFilter name="Filter">
    <Comparison>All</Comparison>
    <Filters type="list">
    <ValueFilter>
    <Table>Application</Table>
    <Column>Name</Column>
    <Comparison>Contains</Comparison>
    <Value>PDFSam</Value>
    </ValueFilter>
    <ValueFilter>
    <Table>Application</Table>
    <Column>Version</Column>
    <Comparison>!VersionLowerThan</Comparison>
    <Value>@(AppVerPDFSam)</Value>
    </ValueFilter>
    </Filters>
    </RootFilter>
    <ReportDefinitionTypeName>BasicReportDefinition</ReportDefinitionTypeName>
    <Columns type="list">
    <Column>
    <Column>ComputerId</Column>
    <Summary></Summary>
    <Table>Computer</Table>
    <Title></Title>
    </Column>
    </Columns>
    </ReportDefinition>
    <IsDrilldown value="true" />
    <CanShare value="null" />
    <Created>2017-06-26T06:42:22.0000000-06:00</Created>
    <Description>Systems with version @(AppVerPDFSam) or higher</Description>
    <Error></Error>
    <Id value="7368" />
    <ImportedPath></ImportedPath>
    <IsEnabled value="true" />
    <Modified>2017-06-29T13:14:42.0000000-06:00</Modified>
    <Name>Latest Version</Name>
    <ParentId value="7367" />
    <Path>PDFSam\Latest Version</Path>
    <TypeName>DynamicCollection</TypeName>
    <Type>DynamicCollection</Type>
    <CustomVariables type="list">
    <CustomVariable>
    <Name>AppVerPDFSam</Name>
    <Value>3.30.2.0</Value>
    </CustomVariable>
    </CustomVariables>
    <Children type="list" />
    </Collection>
    <Collection>
    <ReportDefinition name="Definition">
    <RootFilter name="Filter">
    <Comparison>All</Comparison>
    <Filters type="list">
    <ValueFilter>
    <Table>Application</Table>
    <Column>Version</Column>
    <Comparison>VersionLowerThan</Comparison>
    <Value>@(AppVerPDFSam)</Value>
    </ValueFilter>
    <ValueFilter>
    <Table>Application</Table>
    <Column>Name</Column>
    <Comparison>Contains</Comparison>
    <Value>PDFSam</Value>
    </ValueFilter>
    </Filters>
    </RootFilter>
    <ReportDefinitionTypeName>BasicReportDefinition</ReportDefinitionTypeName>
    <Columns type="list">
    <Column>
    <Column>ComputerId</Column>
    <Summary></Summary>
    <Table>Computer</Table>
    <Title></Title>
    </Column>
    </Columns>
    </ReportDefinition>
    <IsDrilldown value="true" />
    <CanShare value="null" />
    <Created>2017-06-26T06:43:18.0000000-06:00</Created>
    <Description>Systems below version @(AppVerPDFSam)</Description>
    <Error></Error>
    <Id value="7369" />
    <ImportedPath></ImportedPath>
    <IsEnabled value="true" />
    <Modified>2017-06-29T13:14:58.0000000-06:00</Modified>
    <Name>Older</Name>
    <ParentId value="7367" />
    <Path>PDFSam\Older</Path>
    <TypeName>DynamicCollection</TypeName>
    <Type>DynamicCollection</Type>
    <CustomVariables type="list">
    <CustomVariable>
    <Name>AppVerPDFSam</Name>
    <Value>3.30.2.0</Value>
    </CustomVariable>
    </CustomVariables>
    <Children type="list" />
    </Collection>
    </Children>
    </Collection>
    </AdminArsenal.Export>