You are not logged in.
Found it.
Offline
Yes, just download the latest build (3.0.3.65)
http://software.bigfix.com/download/bes … Mapper.exe
Offline
New build is available (3.0.3.135)
http://software.bigfix.com/download/bes … Mapper.exe
- Works with non-english SQL Instances that have property names containing high-bit characters.
Offline
Getting errors with the property mapper after having installed the update for 7.2.4.60.
Sample errors:
Looking up Custom Properties...DBD::ODBC::st fetchrow_array failed: [Microsoft][SQL Native Client]String data, right truncation (SQL-01004)(DBD: st_fetch/SQLFetch (long truncated DBI attribute LongTruncOk not set and/or LongReadLen too small) err=-1) at /<D:\jobs\BigFix Export\BESPropertyIDMapper.exe>BESTools/Databases.pm line 273, <DATA> line 165.
DBD::ODBC::st fetchrow_array failed: [Microsoft][SQL Native Client]String data, right truncation (SQL-01004)(DBD: st_fetch/SQLFetch (long truncated DBI attribute LongTruncOk not set and/or LongReadLen too small) err=-1) at /<D:\jobs\BigFix Export\BESPropertyIDMapper.exe>BESTools/Databases.pm line 273, <DATA> line 165.
Offline
Hey Riel,
This means you have a row in the database we are trying to get that is over 16MB large which is the default max row length we use for this tool. I'm not sure why you would have a row that large.
What Fixlet sites are you subscribed to?
Have you created an custom analyses or properties that are suspiciously large?
Offline
Not that I know of but I will check... which table(s) should I be looking at?
Offline
I mostly just wanted you to poke around in the BES Console and see if any analyses looked really big. You can get your site subscription list from tools->manage sites.
The database tables we would look at are LOCAL_OBJECT_DEFS and EXTERNAL_OBJECT_DEFS but we don't necessarily look at every row for this tool (though I'm not sure why any row would be over 16MB).
If it is possible for you to upload your database to us, I can do the analysis on our side. Just send me an email and I'll give you instructions on how to do it.
Offline
New build is available (3.0.3.166)
http://software.bigfix.com/download/bes … Mapper.exe
- Added a warning message when using a SQLNativeClient odbc driver because the tool will not find any custom or external properties.
- Added a -m <size of result rows> commandline option to fix the problem riel saw with large results being returned.
Offline
This is great information. I do have a question; Does anyone know where the information is stored (in 7.0) for the Manual Computer Groups. It used to be in 'fieldcontents' column in the textfields table. I am trying to write a query to pull all the computers in a certain manual group but I can not find this information in the new 7.0 schema. P.S. I am writting my query in SQL from the database directly.
Offline
Does the BES_COMPUTERGROUPS view do what you are looking for?
Offline