Search the Community

Hi! How can i build a query based on a IP sunnet ? Address: 159.171.10.1 Netmask: 255.255.255.128 = 25 Network: 159.171.10.0/25 Broadcast: 159.171.10.127 HostMin: 159.171.10.1 HostMax: 159.171.10.126 I have now (but it won't do the job) : 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_NETWORK_ADAPTER_CONFIGURATION on SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.ResourceId = SMS_R_System.ResourceId where SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.IPAddress >= "159.171.10.1" and SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.IPAddress <= "159.171.10.126" Any tips, ideas ??

Hello, im in trouble with following error when importing drivers. An error occurred while importing the selected driver I think its the DB Move issue. I tryed the following things: http://www.windows-noob.com/forums/index.php?/topic/5225-sccm-2012-rc2-error-occurred-while-importing-the-selected-driver/page__gopid__24112#entry24112 And i found the Microsoft KB http://support.microsoft.com/kb/2709082 1. Manually set the property back to ON by running the following command against your CM database: ALTER DATABASE <ConfigMgr DB> SET TRUSTWORTHY ON 2. Ensure that the database that was moved is owned by SA. 3. Ensure that Isolation Level is set to 'READ_COMMITTED_SNAPSHOT' - To check the Isolation Level run 'DBCC USEROPTIONS' - If it is set to anything else then 'READ COMMITTED SNAPSHOT', please run following commands: ALTER DATABASE <ConfigMgr DB> SET ALLOW_SNAPSHOT_ISOLATION ON ALTER DATABASE <ConfigMgr DB> SET READ_COMMITTED_SNAPSHOT ON Note: You might have to switch the SQL DB to Single User mode before running the two commands in previous step. Once done, please change it back to Multi User mode. Also make sure that all properties are set correctly under Database Properties - Options But what is correctly? I think it is correctly. But it dosnt work! :angry: Thanks in advance Huebi