Hello and welcome to our Knowledge Base. Our experts provide answers to the most frequently asked questions of our customers. Start your information search here to find your answer quickly and easily.
Please enter your query or select one of the above categories.
All entries (Page 2 / 6)
Is it possible to "move " the history information to a new server name? We recently retired some of our older file servers and the new server have different names. The directory structure (i.e., \dept\dept_name\users) stayed the same.
In the context menu of the Configure Scans dialog (Scan > ConfigureScans) there is an entry "Change Scan Location" in the sub menu "ExpertSettings". Use this option to change the selected directory path, when thedirectory was moved.
I currently have SpaceObserver 3.1.1 installed and want to upgrade to 4.02Is it an easy process?Can I upgrade or is it a re-install?Does the upgrade use the same SQL Database, i.e. upgraded during the install, or does it need a new DB?Do I upgrade the client or the server agents first?
To upgrade youSpaceObServer instance to a newer version (no matter if minor or major update),you just have to install the new version over the existing installation.All the user settings andthe connected database will be kept.We recommend installing theSpaceObServer instances before the SpaceObServer Remote Administration Clients. Note: Please ensure that you are using the same versions of SpaceObServer andRemote Administration Clients.
Hello,we use SpaceObServer and are satisfied with its functions and features. However, our management would like to have an automatically generated report from which they could address obsolete data and mark them for archiving/deleting from production shares. I found out that there is something like OLE Automation available through custom scripting. So I would like to ask you if you could kindly provide us with some already finished and working scripts if they are available?
SpaceObServerships with some OLE Automation example scripts, showing most of the automationfunctionality. Please find this scripts in your Windows start menu entry"OLE Automation Examples" (entry "SpaceObServer") or in theinstallation sub directory "demos". For more detailed documentation of the OLE Automation interface, please take alook at the SpaceObServer help file, Section "OLE Automation".
I believe there is a problem with how Create Date is reported.SpaceObServer reports the same Create Date as my file 's file system create date (seen in Explorer) when it initially scans the file system. If the file is moved my Create Date does not change on my file system. However, when SpaceObServer scans the file system after the file move it will report the file as being Created when it is scanned and entered into the database. This does not match the Create date of the file on the file system.
When youmove a file on your hard disk, SpaceObServer will notice this file as newfiles. To show correct size growth in the SpaceObServer "History" wecannot use the reported creation date of the moved files, because in this casethe file will be reported twice in the SpaceObServer "History".
I would like to read the SpaceObserver tables in SQL server to show the SpaceObserver data with data from an other database.The problem is that when I try get the datetime from the fields in the database by casting them to datetime the result is incorrect.What is the function to translate the floats to the correct datetime?
Date time values:
The representation of dates in the SpaceObServer database is equal to the Delphi TDateTime specification. One reason for this is that it is much easier to support different SQL databases.
In Delphi, TDateTime is a type that maps to a Double. In C++, the TDateTime class corresponds to the Delphi TDateTime type. The integral part of a Delphi TDateTime value is the number of days that have passed since 12/30/1899. The fractional part of the TDateTime value is fraction of a 24 hour day that has elapsed. Following are some examples of TDateTime values and their corresponding dates and times:
0 12/30/1899 12:00 am
2.75 1/1/1900 6:00 pm
-1.25 12/29/1899 6:00 am
35065 1/1/1996 12:00 am
To find the fractional number of days between two dates, simply subtract the two values, unless one of the TDateTime values is negative. Similarly, to increment a date and time value by a certain fractional number of days, add the fractional number to the date and time value if the TDateTime value is positive. When working with negative TDateTime values, computations must handle time portion separately. The fractional part reflects the fraction of a 24-hour day without regard to the sign of the TDateTime value. For example, 6:00 am on 12/29/1899 is –1.25, not –1 + 0.25, which would be –0.75. There are no TDateTime values between –1 and 0.
To convert this value to the MS SQL Server data type datetime us the DATEADD() function:
SELECT DATEADD(dd , LASTSCAN_TIME, '18991230 ') FROM ROOTS
SELECT DATEADD(hh , LASTSCAN_TIME*24, '18991230 ') FROM ROOTS
SELECT DATEADD(mi , LASTSCAN_TIME*24*60, '18991230 ') FROM ROOTS
We have use TreeSize for years an like the product a lot. I am considering SpaceObServer as a replacement and wanted to know if it will work well with a copy of SQL server express taht was installed as part of a BackupExec installation.
SpaceObServer works well with SQL Server Express and is used by many customers in this combination. The version 2000 - 2008 are supported. We have not tested it with the specific SQL Server express that comes with BackupExec, but I don ' expect any problems. Our trial version allows you test this for free and our support will assist you in case a problem occurs.
We need to automate a report including type of file (extension based) per sub folder.We may do it manually by clicking each home folder but as we have 1000+ home folde, this is not affordable.A way to address this ?
You canuse the SpaceObServer OLE Automation interface (See: Help file > section OLE Automation) to automate SpaceObServerexports by your own scripts or executable. You canalso use the "SpaceObserverCmdLineParser.exe" to do this. E.g.:SpaceObServerCmdLineParser.exe/EXTENSIONSLIST "C:\Reprots\C_file_types_share1.csv""\Server1\share1"SpaceObServerCmdLineParser.exe/EXTENSIONSLIST "C:\Reprots\C_file_types_share2.csv""\Server1\share2"...
Our SQL 2005 express database has reached its maximum limit. I urgently need to purge data older than 30 days. Please provide me a sample SQL statement to purge data older than 30 days.
You canpurge data older than X days within the Configure Scans dialog (Scan >Configure Scans > Scan Options > Archive Size data for X days). You haveto run an update scan after changing this option, or run "SynchronizeDatabase Values" from within the lists context menu (context menu >Expert Settings > Synchronize Database Values).
I need to move my spaceobserver database to a different server. Can I just move my database and update the connection info within SpaceObserver, or are there additional steps?
If you wantto move databases in the same type of SQL servers, it is sufficient to justmove the database from one SQL server to another. Since SpaceObServer V4 you can do this automatically, and independent of SQLserver types, by using the "Export to SQL Server" function (Scan >Configures Scans > Right click on the scans to exports > Export>Export to SQL Server).
When I attempt to contact to the SpaceObserver server from a client I get 'Server does not exist or access is denied '. I set the the server to use SQL with integrated logon. My domain account has admin rights as well. Why do I get this error?
One reason for this could be that your account does not have access rights to the MS SQL server. Even if this is your administrator account, this does not automatically mean that this account has access rights to the MS SQL server. Another possible reason could be that the MS SQL server was not configured to allow remote access or allow access via Windows authentication.Both can be configured in your SQL Management Studio.
We have SpaceObServer server installed on multiple file servers throughout our company. We have set scheduled scans, configuring the "home server " for each box to be itself (so every machine scans only its own content). Here is our problem: serverA will actually be the one running the scan of serverB, even though serverA is its own home server.
You can configure each scan to be executed by a certain server. You can do this in the Configure Scans dialog ("Scan > Configure Scans) by choosing "Expert Settings > Set Observing Server" in the right click menu.
The "Observing Server" is set by default to the server name that added the new Scan. If the "Observing Server" is set (not blank), only this server will execute scans for this root directory, no matter from with client or schedule job the scan was triggered. You can also enter more than one server name. The names have to be separated with semicolon (";") only
i have configured a connection to an oracle database. the connection works, the test button comes back with success, but when i try to run a scan, i get 'ora-00942: table or view does not exist 'any help?
It seems the the SpaceObServer Agent, which is a separate process that is running as a system service, has problems accessing the database. Could you please check the Event Log, especially "System" and "Application" for entries that could be related to this issue?